Selecting the correct value from a drop

[Anon]

Hi,
I currently have an admin page where i add/edit business addresses.
When i insert new details into the mysql DB the "suburb" values are inserted through the use of a drop down menu.
This all works fine, my problem is that when it comes to editing existing details i can get the values related to the $id easy enough but how can i get the suburb value to be selected in the drop down menu (selected)?
Any ideas?
camcim

[Anon]

you must add a condition statement to the dropdown. I suggest that you store the list of suburbs in the db or in a separate array.

first pull data from the db
let's assume all the suburb names are stored in $suburb_array and the current suburb name is $suburb

<select name="suburb">
<?
foreach ($suburb_array as $value) {
echo '<option'; if ($value == $suburb) {echo ' selected';} echo ">$value";
}
?>
</select>