RE: newbie Dynamic Drop down lists using mysql

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