populating a select menu from mysql

[djbob2k1]

I have no idea how to go about this. so i would apreciate some help 🙂 i want to populate the values in a html select menu from database values in one table

so there will be multiple values i can get it to put 1 value from the table in but the others dont appear in the select menu.

i want to use php to do this and i need to keep it as simple as possible. help very much appreciated.

regards

[Anon]

That's an easy one. Here's some snippets:

<SELECT name="select_name"><OPTION SELECTED>Choose One</OPTION>

<?php
$who = mysql_query("SELECT * FROM table_name",$db);

while ($myrow = mysql_fetch_array($who)) {
printf(" <OPTION>%s</OPTION>\n",$myrow['field_name']);
}
?>
</SELECT>

You can just cut and paste this and change the necessary values.

Have fun!