php single to combo box

[mpc123]

So I have a single drop down menu populated from data base, now i want to get a bit snazzy and select from the first and from the selected then populate the 2nd drop down to select and then link to a url.

Here is my code for first drop down which is populating fine, where do i go from here?

$query = "SELECT DISTINCT Manufacturer from manufacturers  ORDER BY Manufacturer ASC";
// Execute it, or return the error message if there's a problem.
$result = mysql_query($query) or die(mysql_error());

$dropdown = "<select name='products'>";

while($row = mysql_fetch_assoc($result)) {

  $dropdown .= "\r\n<option value='{$row['Manufacturer']}'>{$row['Manufacturer']}</option>";

}

$dropdown .= "\r\n</select>";

echo $dropdown;

mysql_close($con);
?>

[diafol]

I recently posted a code snippet for linked dropdowns. It may be worth a look, but again if you have volatile data (changes often), perhaps not so. Anyway:

http://www.daniweb.com/web-development/php/code/475238/linked-dropdowns-select-fields-for-static-ish-data

[mpc123]

Hi that looks great but the info in the database does change alot

[mpc123]

anything else somebody can offer please?

[Fernando_4]

So basically you want to populate a second select based on what was selected on the one you posted, correct?

We need a bit more info if that's the case.

1. Do you want to do this after a reload? The user selects a manufacturer and posts the form in order to create the second select.
2. Do you already have any data to create the second one? What would the second select take as data to be created, and on which page would it appear, the same or another?
3. Would you want the second select to be populated asynchronously with AJAX?

Try figuring out what user experience you want and then fill in the gaps for us^^

[diafol]

Just finished a code snippet for ajaxified linked dropdowns:

http://www.daniweb.com/web-development/php/code/476623/ajaxed-linked-dropdowns-select-fields-for-volatile-data