link datatable to combo box or Session variable

Issues related to forms.
Post Reply
Chris.sedgwick
 
 
Posts: 4
Joined: Thu Apr 30, 2020 6:57 pm

link datatable to combo box or Session variable

Post 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.
Chris.sedgwick
 
 
Posts: 4
Joined: Thu Apr 30, 2020 6:57 pm

Re: link datatable to combo box or Session variable

Post 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?
User avatar
Pablo
 
Posts: 23025
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: link datatable to combo box or Session variable

Post 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.
Post Reply