Retrieving MySQL data to display in a form

[ddrfreek]

Right now I have a configure page on my website. Most fields in the HTML form as just text, but I need one of the fields to be a drop down menu. Now, for the other fields I just used the value setting to echo the data that was already stored in the database. However, for the drop down menu, I need to find a way for it to not only set whatever the selected value is, but to be able to recall what was previously selected next time the page is refreshed as the default option.

So, simplified, my question is how can I display the MySQL value as the default value in a drop down menu?

[leatherback]

Depends a little on how your dropdown is created. If it comes froma table, then during thecreation you could do something like:

while(...)
  {
  $sel = "";
  if($row['ID'] == $selected_value;
   {
   $sel = " selected ";
  }
 echo "<option vlaue=$row[id] $sel >$row['bael']</option>";
  }