How do I reflect the content of a column from a database table in a select menu?

[Morris2]

Hi.

Maybe a tricky question?

 

How do I reflect the content of a column from a database table in a roll down select menu in the browser?

 

Let's say that the content of the table column is:

 

Anna

Michael

 

These names should be reflected in this select menu like this:

 

<select name="friends">

<option value="Choose a name">Choose a name</option>

<option value="Anna">Anna</option>

<option value="Michael">Michael</option>

 

So visitors can choose a name, and thereby turn it into a variable, for reuse in the database.

 

Best regards Morris

 

[MasterACE14]

  echo "<select name=\"friends\">";
  echo "<option value=\"Choose a name\">Choose a name</option>";
  $q = mysql_query("SELECT `name` FROM `table`");
  while($row = mysql_fetch_assoc($q)) {
    echo "<option value=\"".$row['name']."\">".$row['name']."</option>";
  }
  echo "</select>";