Dynamic dropdown with dynamically selected value

[jrobles]

I have a drop down that is dynamically populated with data from my mysql table. Now I need to have a value from said drop down list automatically selected based on the id passed in the url. My query works fine but I am stuck on the syntax to select the appropriate drop down value.

 

Here is my while loop that populates the drop down

<select name='dropdown' id='dropdown'>
<option value='0'>Select a Value</option>";
if (mysql_num_rows($result) > 0)
{while($row = mysql_fetch_object($result))
echo"<option value='$row->ID'>$row->Name</option>";}
echo"
</select>

 

 

The drop down I am doing will be on a form that is editing a users address. So if the user lives in 'FL' I would like the option for 'FL' to be

<option value="FL" selected>Florida</option>

[PFMaBiSmAd]

Untested, but should work -

{
$value = 'FL'; // get the value from the correct place
    while($row = mysql_fetch_object($result)){
        $selected = ($value == $row->ID) ? "selected='selected'" : "";
        echo"<option value='$row->ID' $selected>$row->Name</option>";
    }
}

 

[jrobles]

Thanks for your help, but that didnt seem to work. any suggestions?

[PFMaBiSmAd]

Not unless you tell us what exactly it did do and what your current code is and what you found when you investigated why it did not work. You know, provide some feedback. For all we know, your $value that you put into the code is not what you expect.

 

[jrobles]

sorry, the only value available was 'State'