Jump to content

Archived

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

OCHE1976

Create Drop Down Menu From List in SQL

Recommended Posts

I have a members list in a database. I have some filling in information all the time about these members. I do not want him to have to enter the name all the time. I would like to give him a drop down menu with all the names. However, this member list changes all the time. If the name is not in the table, I will give him the ability to enter a new name into the database. That I know is easy.

So, to the question: How would I create a drop down menu from a list within an SQL Database?

Thanks,
David

Share this post


Link to post
Share on other sites
[code]
    mysql_select_db ("databasename");
         echo "User : <select name=UserID><option value='.'>--Select One--</option>";
         $UserTableQuery = mysql_query ("select DISTINCTROW Fieldname from Tablename order by Fieldname");
         while ($UserTableRow=mysql_fetch_array($UserTableQuery)) {
         echo "<option value='".$UserTableRow[Fieldname]."'>".$UserTableRow[Fieldname]."</option>\n"; }
         echo "</select><p>";
[/code]

Share this post


Link to post
Share on other sites

×

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.