Dynamically selected value from drop down list

[micmac]

Hi all,
If i have the following select box:

<select name="age" id="age">
	<?
foreach(range(18, 50) as $age) {
    echo "<option value=\"$age\">$age</option>";
}
?>   

	</select>

how can i get my SQL query result to become the "selected" value from the drop down list?
For example, if i do my query and the $age value is equal to '29' i want this value to be the selected item from the drop down list.

Any ideas?

Cheers,
micmac

[viper21634]

ok, i think this is what you are going for

<select name="age" id="age">
<?
foreach(range(18, 50) as $age) {
     if($age == $query_value)
     {
           echo "<option value=\"$age\" selected>$age</option>";
     }
     elseif($age !== $query_value)
     {
           echo "<option value=\"$age\">$age</option>";
      }
}
?>   

</select>