help with drop down menu box

[Anon]

i just need some quick help with a table that has a ton of names. What i wanted to do is place those names in say one of those drop down menus.

how would i go about doing this? i'm a bit of a newbie to php, so any help would be greatly appreciated.

thanks

[bastien]

I assume you can do the query...

<?
$sql="select username from table";
$result = mysql_query($sql, $conn);
echo "select name=username size = 1>";
while $row=mysql_fetch_array($result){
$username=$row["username"];

 echo "<option value=\"$username\"> $username</option>";

}

echo </select>";

?>

hth