How do i set selected item in a dropdown PHP MySQL

[osamaboshi]

I have Table (bus)
columns (bus_id)(bus_no)
I tried echo <select> multiple with multi selection , I tried the below code but its repeat the (bus_no)
please help me to echo all bus and selected some buses and echo "selected" beside selected buses

<form name="editstudent" method="get" action="testmulti.php">
<select name="numBus[]" multiple>
<?
$selBus=mysql_query("SELECT * FROM najdsy_bus order by bus_id");
while ($rowBus=mysql_fetch_array($selBus)){
foreach ($numBus as $key=> $value){
if ($rowBus[bus_id]==$value){
$SelectedBus="selected";
}else{
$SelectedBus="";
}
echo '<option value="'.$rowBus[bus_id].'"'.$SelectedBus.'>'.$rowBus[bus_no].' '.$SelectedBus.'</option>';
}
}
?>
</select>
<br/>
<input type="submit" value="test">
</form>

[minimihi]

With each while loop you receive one row to $rowBus (with each loop variable is overwritten with new value), so there is no need to use foreach loop.

In foreach loop you're taking current row index to $key and value to $value. Then compare current row 'bus_id' value to $value variable, which always return true, since they contain same value.
Why are you doing this?

Also, when you describe array index, always use quotes. So that PHP wouldn't search for defined constants to insert into index.
For short, use $rowBus['bus_no'] instead of $rowBus[bus_no]

Code: Select all

<?
$SelectOptionWithThisID = 7;
$selBus=mysql_query("SELECT * FROM najdsy_bus order by bus_id");
while($rowBus = mysql_fetch_array($selBus)){
    if ($rowBus['bus_id'] == $SelectOptionWithThisID){
        $SelectedBus="selected";
    } else {
        $SelectedBus="";
    }
    echo '<option value="'.$rowBus['bus_id'].'"'.$SelectedBus.'>'.$rowBus['bus_no'].' '.$SelectedBus.'</option>';
}
?>