Reputation: 871
I want to dynamically select the default value on the drop down menu
the value are stored on mysql server which is retrieved by $row['order status']
and it has only 4 values stored in the server Open Pending Closed Success
so i have choose the default value from these 4 value
$selected are all initialised to false or '0' or disabled
i am trying the following code but it is not working
if($row["Order Status"]=="Open"){
$selected='selected';
}
if($row["Order Status"]=="Pending"){
$selected1='selected';
}
if($row["Order Status"]=="Closed"){
$selected2='selected';
}
if($row["Order Status"]=="Success"){
$selected3='selected';
}
echo"
<select id='txt_orderstatusid_' class='txt_id_' >
<option ".$selected." value='Open'>Open </option>
<option ".$selected1." value='Pending'>Pending </option>
<option ".$selected2."value='Closed'>Closed </option>
<option ".$selected3."value='Success'>Success </option>
</select>"
i have tried this also
echo "<select id='txt_orderstatusid_' class='txt_id_' >
<option selected=".$selected." value='Open'>Open </option>
<option selected=".$selected1." value='Pending'>Pending </option>
<option selected=".$selected2."value='Closed'>Closed </option>
<option selected=".$selected3."value='Success'>Success </option>
</select> "
it also does not work
Upvotes: 0
Views: 656
Reputation: 13738
You can check db values at option directly Try
<select id='txt_orderstatusid_' class='txt_id_' >
<option <?php if(isset($row["Order Status"]) && $row["Order Status"]=="Open") echo 'selected="selected"';?> value='Open'>Open </option>
<option <?php if(isset($row["Order Status"]) && $row["Order Status"]=="Pending") echo 'selected="selected"';?> value='Pending'>Pending </option>
<option <?php if(isset($row["Order Status"]) && $row["Order Status"]=="Closed") echo 'selected="selected"';?> value='Closed'>Closed </option>
<option <?php if(isset($row["Order Status"]) && $row["Order Status"]=="Success") echo 'selected="selected"';?> value='Success'>Success </option>
</select>
Upvotes: 4