Drop Down Lists

[Anon]

If the below code gives a static list in a drop down box, how would you make it so the list came from a table column called Industry in the Lists table?

<form action=\"http://localhost/insert_client.php\" method=\"post\">
<table border=0 font-size=8>
<tr><td><font=8>Industry</font></td><td>
<select name=\"Industry\">
<option value=\"Banking\">Banking

<option value=\"Commerce\">Commerce
<option value=\"Energy\">Energy
<option value=\"IT\">IT
<option value=\"Media\">Media
<option value=\"Market Data\">Market Data
<option value=\"Project Management\">Project Management
</select><br></td></font></tr>

[samscripts]

i'm assuming you are using a mysql database?

$results = mysql_query("SELECT industry FROM lists ORDER BY industry");

echo '<select name="industry">';
while( list($industry) == mysql_fetch_row($results)){
echo "<option value='$industry'>$industry";
}
echo "</select>";