xjshiya xjshiya - 5 months ago 38
PHP Question

<select> dropdown default value

I have this code:

$res1=mysql_query("SELECT * FROM aircraft where acode = '$_POST[ac]'") or die(mysql_error());

echo "<center><table><form name=\"frmMain\" method=\"post\">
<tr><td><font face=consolas><b>Aircraft Code:</b></font></td><td><input type=text name=arc value='$airc' readonly=readonly></td></tr>
<tr><td><font face=consolas><b>Aircraft Model:*</b></font></td><td><input type=text name=am value='$amode'></td></tr>
<tr><td><font face=consolas><b>Status:*</b></font></td><td><input type=text name=st value='$stat'></td></tr>
<tr><td><font face=consolas><b>Remarks:*</b></font></td><td><input type=text name=rm value='$rem'></td></tr></table>";

On submit 'search' button, this code displays the data from aircraft table. The user is allowed to update the data with the (*) sign.

enter image description here
Since the Status are the following by default (Available, Not Available), I changed this

<tr><td><font face=consolas><b>Status:*</b></font></td><td><input type=text name=st value='$stat'></td></tr>

to this,

<tr><td><font face=consolas><b>Status:*</b></font></td><td><select name=st>
<option value=Available>Available</option>
<option value='Not Available'>Not Available</option>

But I want the dropdown to have it's default value depending on
since this is an update form. If the data being retrieved has it's status 'Available', then the dropdown should have it's default value as 'Available'. How can I achieve that? I tried
<select name=status value='$stat'>
but it doesn't work. Any help will be appreciated. Thanks!


Just put selected="selected" on the option depending on your $row['status'],

<option selected="selected" value="available">Available</option>