xjshiya xjshiya - 1 year ago 123
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!

Answer Source

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

<option selected="selected" value="available">Available</option>
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download