Give data to select statement form MySQL Db

[Anon]

hi,

I'm looking for some code examples to create a page with a "down box form" (sorry I don't know which is the right word in english, may be a combo box) where items are dinamically loaded from a MySql Db with a query.

In other words I would like that the following html code:

<select size="1" name="combo">
<option>item1</option>
<option>item2</option>
<option>item3</option>
</select>

is created by php where there are the "option" parts...items should be taken from a table...

Have you got any reference about !?

Thank you very much for your help

Fabio

[Anon]

Fabio,

Try this:

################################

<select name="combo">

<?

$query = mysql_query("SELECT item,itemname FROM tablename");

$result = mysql_fetch_array($query);

do {

?>

<option value="<? print $result["item"]; ?>"><? print $result["itemname"]; ?></option>

<?

} while ($result = mysql_fetch_array($query);

?>

</select>

#################################

Hope this helps

Mike
www.digitalegg.net