Select Statement Does Not Show Current Data

[jeff_lawik]

Hello,

I am trying to select data from a MySQL database, and have it printed in the fields of a form.

Ex: <input type=\"text\" size=\"5\" name=\"entry1_high\" value=\"$as_row[entry1_high]\"></td>

This works perfectly fine (accompanied by all the other MySQL queries and forms, ecterera.) but I don't know how show data in the form of a select statement so that when the page is loaded, it will show the current data listed in the database.

Please Help!

Jeff 🙂

[dnszero]

Just put it in a loop:

$sql = "SELECT id, whatever FROM yourtable";
$result = mysql_query($sql);

print "<select name=blah>\n";
while ($row = mysql_fetch_row($result)){
   print "<option value='$row[0]'>$row[1]</option>";
}
print "</select>";