Page 1 of 1

link datatable to combo box or Session variable

Posted: Mon May 04, 2020 2:19 pm
by Chris.sedgwick
i have the Datatables extension, i have successfully connected to MySQL and can pull data, i can filter if i manually type the WHERE clause, i'd like to link the where clause to a combo box or a session variable,

i tried MySQL Filter: username={$_SESSION['username']}

but that didnt work, i do have the login toolbox all setup and working, i have the Login Name showing my username too.

Re: link datatable to combo box or Session variable

Posted: Mon May 04, 2020 2:25 pm
by Chris.sedgwick
or is it possible to link to (ID)'s? i have a HTML box with session variables in. can i use the value of (ID) Html1 in my WHERE clause?

Re: link datatable to combo box or Session variable

Posted: Mon May 04, 2020 3:22 pm
by Pablo
I'm sorry, I do not have standard solution for linking a combobox. I think this will requires you to write custom code.