2 Issues...Need Help, please.

[Anon]

I was hoping someone can help me out with the following 2 issues.

I. Populating a drop down menu with info from a MySQL Table.

Can someone provide me with any example of pre-made code that may be availble?

I just want the drop down menu to have 1 field. It will be called "Referrers" basically, the name of clients already in the database...

[bastien]

//create the select box
echo "<select name=referrers size=1>";
echo "<option value="">Please choose</option>";

//create the sql query for the data
$sql = "select clientname from tableX";
//execute the query
$result = mysql_query($sql, $conn) or die "couldn't take to database!");
//print the results to the options
while $row = mysql_fetch_array($result){

$name= $row["clientname"];

echo "<option value=$name>$name</option>";
}
//close the select box
echo "</select>";

hth

bastien