Drop down boxes - help needed

[Anon]

I am new to PHP and am having problems inputting a drop down box with data from MySQL database.

Any help will be appriciated.

[mike_y]

echo "<select name=myname>";
while($row=mysql_fetch_row($result))
echo "<option name=$row[0]>$row[1]</option>";
echo "</select>";

That's the basic syntax...

[jamesh]

There is also an excellent article on this at www.thickbook.com/extra/php_loopoption.phtml. I would check that out, since it covers in good detail how to pull elements from your MySQL db into a selection box.