HOW TO POPULATE A DROP DOWN WITH SQL

[Kathy]

Can anybody explain to me or send me links to some tutorials on how to populate a drop down menu with a database?

What I ultimately want to achieve is to have a drop down box, containing types of businesses populated from a database and depending on what option you choose from the drop down on clicking an option eg. Bakeries this will then populate another drop down, from here you will choose a company name, eg. Margerie's Baked Goods, on clicking this it will bring up contact information, which I'm guessing should be populated in text fields?

[milesap]

Extract the values from the database and put them into an array. You can use the mysql_fetch_array function to achieve this. Then add a foreach loop on the array to print out all the values.

[seventheyejosh]

like so:

 

$res=mysql_query("SELECT * FROM table WHERE 1");

echo '<select name="name">';

while($row=mysql_fetch_array($res)){

echo "<option value=$row['value']>$row['display']</option>";

}

echo '</select>';