Gary Brett asked 8 years ago
Hi there, I have created mysql query to output a pivot style table that works great with the grids. Is it possible at all to have a select filter above the grid that would allow me to choose which query/grid to load?
At present I use 3 tabs, 2015, 2016 & 2017 for the years but would be much easier and less work to use a select for this feature.
I have pasted code over here, I have 3 of these in each page, one for each year filtered in the WHERE clause, if 1 select filter could target and load each query would be great.
1 Answers
Abu Ghufran answered 8 years ago
Hello,
You can have a select dropdown with these options and submit form (using $_GET) with dropdown onchange event.
In you page you can put this GET values in select_command in where filter.
Your Answer
