Entry

How do would you go about populating a drop down menu box with information from a mySQL database?

Jun 29th, 2002 18:38
Marti, Warren Hutchy,

It's relatively easy...

<!-- ... -->
<form method="post" action="dropdown.php">
<select name="dropdown">
<?php
$query = mysql_query('select id, title from dropdown') or die
(mysql_error());
while($row = mysql_fetch_array($query)) {
  echo("<option value=\"${row['id']}\">${row['title']}\n");
}
?>
</select>
</form>
<!-- ... -->