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.
link datatable to combo box or Session variable
Forum rules
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901
MUST READ:
http://www.wysiwygwebbuilder.com/forms.html
http://www.wysiwygwebbuilder.com/form_wizard.html
Frequently Asked Questions about Forms
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901
MUST READ:
http://www.wysiwygwebbuilder.com/forms.html
http://www.wysiwygwebbuilder.com/form_wizard.html
Frequently Asked Questions about Forms
-
-
- Posts: 4
- Joined: Thu Apr 30, 2020 6:57 pm
-
-
- Posts: 4
- Joined: Thu Apr 30, 2020 6:57 pm
Re: link datatable to combo box or Session variable
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
I'm sorry, I do not have standard solution for linking a combobox. I think this will requires you to write custom code.