<select> menu value

[arsenalfan14]

I want to get a value from my database and then have a <select> menu with the <option selected> being the number that is in the database.

Say, I get a field from the table that is 2. I want this:

<option value="1">England</option>
                <option value="2" selected="selected">Brazil</option>
		<option value="3">Cameroon</option>

If the value from the field = 1, the <option value="1" should have the selected...

Thanks.

[tekky]

while($row=mysql_fetch_assoc($result))
{
    $i++;
    echo '<option value=' .$i. '>' .$row['country']. (($i == $row['id']) : ' selected=selected' ? ' '). '</option>';
}

something like that should work...