When I run the following code it runs through the entire list of suburbs and only displays the last one rather than the selceted suburb.
What am I doing wrong?
<?php
$query="select * from tblStaff where StaffID=$staffID";
$result=@mysqli_query($dbc,$query);
$row=mysqli_fetch_array($result,MYSQLI_ASSOC);
$selected_suburb=$row['Suburb'];
echo"<label>Suburb</label><br />";
echo"<select name=\"Suburb\">";
$query="select suburb_id, suburb, state, postcode
from tblPostcodes
order by suburb,state, postcode asc;";
$result=@mysqli_query($dbc,$query);
while($row=mysqli_fetch_array($result,MYSQLI_ASSOC)){
$selected="";
foreach($row as $suburb_id => $suburb){
if($row['suburb_id']==$selected_suburb){
$selected="selected";
}
echo"<option value={$row['suburb_id']}
selected=$selected>
{$row['suburb']} {$row['state']} {$row['postcode']}</option>";
}
}
echo"</select>";
?>
