Jump to content

[SOLVED] dropdown list


onthespot

Recommended Posts

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

<?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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.