Dropdown Box using Database column

[Scud]

Hi guys;
I'm new here, was hoping some of you guys could help me out.

Basically I'm wanting to set up a page where a user can select from a drop down box a list of different data, however this data is all stored in a database. Is it possible so on page load or when clicking the dropdown box that the data is pulled from the database and can be an option for the user to select.

[Ciary]

you cant imagine how common that question is:

$link = mysql_connect("myserver","root","");
mysql_select_db("mydb",$link);
 
$result = mysql_query("SELECT mycolumn FROM mytable",$link);
$arr = mysql_fetch_assoc($result);
 
mysql_free_result($result);
mysql_close($link);

then your select would be like this:

<select>
<?php foreach($arr as $val){
echo "<option id='option-".$val.">".$val."</option>\n";
} ?>
</select>

[Atli]

The mysql_fetch_assoc function only returns a single row, not the entire table.

It should be more like:

$link = mysql_connect("myserver","root","");
mysql_select_db("mydb",$link);
 
$result = mysql_query("SELECT mycolumn FROM mytable",$link);
if($result) {
  echo '<select name="myselect">';
  while($row = mysql_fetch_assoc($result)) {
    echo "<option value=\"{$row['mycolumn']}\">{$row['mycolumn']}</option>";
  }
  echo "</select>";
}
else {
  echo "<p>No data</p>";
}
 
mysql_free_result($result);
mysql_close($link);