Pulling a drop down list from a product table

[tomfmason]

I am wondering how I can print product names, from a product table, into a drop down menu? Any suggestions would be greatly apperciated.

[freakus_maximus]

Making some assumptions about your table name and column names in your db, this should do it.


[code]<select id="productnames" NAME="productnames">
<?
$result = mysql_query ("SELECT productnames FROM producttable")
  or die ("Query failed");
while($row=mysql_fetch_array($result)){
    echo '<option value="' . $row['productname'] . '">' . $row['productname'] . "</option>\n";
}
?>
</select></P></TD>[/code]