I have a Drop down list that is being populated from a MySQL database. I want to be able to create a 2nd drop down list for certain items in the first drop down list. My first drop down list, lists categories of businesses. If a user selects "Restaurants" I want a second drop down list to appear where the user can choose a cusine if they want. I don't want it to be necessary to select an option from the second list but I want them to be able to. I dod have the first drop down list working. The code follows. I am not sure how to get started on the 2nd list. Any hints, points in the right direction, etc will be appreciated. Thanks!
$cxn = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
mysql_select_db($database,$cxn);
$query = "SELECT DISTINCT Category FROM clients ORDER BY Category";
$result = mysql_query($query,$cxn)
or die ("Couldn't execute query.". mysql_error());
/* create form containing selection list */