onthespot Posted August 19, 2009 Share Posted August 19, 2009 I have the following code, which brings up a list of all the users who are registered on the site. However, I want there to be an option at the top saying NONE, and then the list below. So a dropdown that will default to NONE, and if clicked you see all the users, but still have NONE at the very top. Any ideas how I would alter the following code to achieve this? Thankyou <?php $res=mysql_query("SELECT username FROM ".TBL_USERS."") or die(mysql_error()); while($row=mysql_fetch_assoc($res)){ $username=htmlspecialchars($row['username']); echo "<option value=\"$username\">$username</option>"; } ?> Link to comment https://forums.phpfreaks.com/topic/170966-solved-dropdown-list/ Share on other sites More sharing options...
Catfish Posted August 19, 2009 Share Posted August 19, 2009 <?php $res=mysql_query("SELECT username FROM ".TBL_USERS."") or die(mysql_error()); echo "<option value=\"NONE\">NONE</option>"; while($row=mysql_fetch_assoc($res)){ $username=htmlspecialchars($row['username']); echo "<option value=\"$username\">$username</option>"; } ?> Link to comment https://forums.phpfreaks.com/topic/170966-solved-dropdown-list/#findComment-901742 Share on other sites More sharing options...
onthespot Posted August 19, 2009 Author Share Posted August 19, 2009 Thanks Link to comment https://forums.phpfreaks.com/topic/170966-solved-dropdown-list/#findComment-901743 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.