Create Drop Down Menu From List in SQL

[OCHE1976]

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

[jvrothjr]

[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]