[Resolved] displaying previously seleted menu option when editting

[peanutgallery83]

As part of setting up an account, users have to select from a drop down menu a region where they reside. The choices in this drop down menu are pulled from a table 'regions'. All of their registration data is then stored in the table 'reflist', with the "region" info stored in column named 'region'.

The problem that I'm having, is that in the area where users can later edit their account, I cannot get the drop down menu to display their previous selection (the region stored in the 'reflist' table).

How would I go about doing this? Is it even possible?
The code below is what I'm using for the drop down to display the choices of regions in the database table.

Thanks in advance.

Landis

<select name="region" id="region">
                  <?
// put data into drop-down list box 

while ($row = mysql_fetch_array($result1)) { 

$region = $row["region"]; 

echo "<OPTION value=\"$region\">$region</OPTION>"; 

} 
?>
</select>

[jpmoriarty]

the code (in html) would be:

<select name="region" id="region"> 
<OPTION value="1">1</OPTION>
<OPTION value="2">2</OPTION>
<OPTION value="3">3</OPTION>
<OPTION value="4" selected>4</OPTION>
</select>

so if you modify your loop to delay the text SELECTED in your required option tag it will do it.

[kburger]

echo "<OPTION value=\"$region\"";
if ($row["region"] == $region) echo " SELECTED";
echo ">$region</OPTION>";