Thanks for the information and help,
The query can solve server side, but client side, user might select any one
dropdown, for example, user might select manager from drop down without
choose Department dropdown.
For this case, application needs inject data for supervisor and lower level,
Thanks again for helping,
Regards,
Iccsi,
"Jim Giner" wrote in message news:8C.41.29774.C0E5AF15@xxxxxxxxxxxx...
On 7/31/2013 9:37 PM, iccsi wrote:
I have 5 SELECT for Department, Manager, supervisor, Group Leader and
Employees
I want to every SELECT list narrow down for an upper SELECT.
For example, once user select Department then all Manager, Supervisor,
Group Leader and Employee list will be narrow down by department and
same for manager and supervisor and so on.
I can use iframe or jQuery to do every level, but it needs to call
iframe or jQuery to 5 levels.
I would like to know are there any better way to handle this situation,
Your help and information is great appreciated,
Regards,
Iccsi,
How about using just one select and add variables to the where clause?
Set the variable(s) to the values that you want to filter on.
For ex.:
your query is
$sel = 1;
$q = "select Department, Manager, supervisor, Group Leader,Employees
where $sel";
Then when the user selects a department $d:
$sel = "Department = '$d'";
OR if you have selected a department $d and a manager $m:
$sel = "Department ='$d' and Manager='$m'";
One query. A variable 'where' clause.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
