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>"; } ?> Quote 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>"; } ?> Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/170966-solved-dropdown-list/#findComment-901743 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.