From the drop-down menu, find the link between the two drop-down lists of php.

! (UI) after selecting a department, the employee name is obtained based on the selected department. (UI. Code for the two lists: & quot; echo & quot;-Select-& amp; nbsp; & quot;. $ gzh _ php drop-down menu database

After selecting a department, the employee's name is obtained based on the selected department.
Code for two lists:

"

Echo "-Select -";
@ Include "conn. php"; // link to the database
$ Gzh_num_result = mysql_query ("select gzh_num, gzh_name from gongzhong where gzh_renum = 0 order by gzh_num ;");
While ($ gzh_num_row = mysql_fetch_array ($ gzh_num_result ))
{

List ($ gzh_num, $ gzh_name) = $ gzh_num_row;

Echo"". $ Gzh_name .""; // Echosuboption ($ gzh_num, @ $ _ GET ['gzh _ num']) ;};?>           Echo"-Select-";
    ". $ Yg_name ."";};?>