[PHP] RE: newbie Dynamic Drop down lists using mysql

[Bobby Rahman]

Hiya

Im looking for any tutorials/snippets of code to show me how to code a 
dynamic drop down box/list in a php form.

e.g a drop down menu of all current users (I assume this will need to 
connect to mysql db and select all usernames from table user and place in 
the menu.

here what I have so far
<?
$connection = db_connect();
$querystring = ("select username from user");
$db_result = mysql_query($querystring);
(if mysql_num_rows($db_result))
{
 while ($row = mysql_fetch_row($db_result))
  {
 print("<option value=\"$row[0]\">$row[0]</option>");
  }
}
else
{
print("<option value=\"\">No users created yet</option>");
}
?>

Any URLS will be much appreciated.

Thanks

Bob

_________________________________________________________________
Express yourself with cool emoticons http://www.msn.co.uk/messenger
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php