[SummerL]

I have got this drop down list populated from the database, upon selection it should display another drop down list as well as diplay of results in table form..
The thing is the second drop down list and the results weren't displayed Anyone know why? Thanks in advance..

first drop down list that is populated from the database

Code:

// get the aircraft type 
$queryAircraftType = "SELECT distinct AircraftType FROM report"; 
$resultAircraftType = mysql_query($queryAircraftType) or die ("couldn't execute query."); 
$row_num_links_mainAircraftType =mysql_num_rows ($resultAircraftType);

displaying of results upon selection of first drop down list

Code:

<?php 
if (isset($_POST['AircraftType'])) 
{ 
$queryAircraftType = "SELECT AircraftType FROM report where aircrafttype='".$_POST['AircraftType']."'"; 
//echo $query; 
$resultAircraftType = mysql_query($queryAircraftType) or die ("couldn't execute query ".mysql_error()); 
while ($row = mysql_fetch_array($resultAircraftType)) 
{ 
extract($row); 
echo "<tr> 
<td>$row[ReportID]</td> 
<td>$row[AircraftTailNo]</td> 
<td>$row[AircraftType]</td> 
<td>$row[ServicingType]</td> 
<td>$row[AirFrameHours]</td> 
<td>$row[DefectInfo]</td> 
<td>$row[Rectifications]</td> 
<td>$row[Comments]</td> 
<td>$row[RelatedDoc]</td> 
<td>$row[UserID]</td> 
</tr>"; 
} 
} 
          
?>

second drop down list populated from first drop down

Code:

<?php 
if (isset($_POST['AircraftType'])) 
{ 
$queriesAircraftType = "SELECT AircraftTailNo FROM report where aircrafttype='".$_POST['AircraftType']."'"; 
//echo $query; 
$resultsAircraftType = mysql_query($queriesAircraftType) or die ("couldn't execute query ".mysql_error()); 
if ($resultsAircraftType) 
{ 
echo "<select name=\"AircraftTailNo\">"; 
while ($rowsAircraftType = mysql_fetch_array($resultsAircraftType)) 
{ 
extract($rowsAircraftType); 
echo "<option value=\"".$rowsAircraftType['AircraftTailNo']."\">".$rowsAircraftType['AircraftTailNo']."</option>"; 
} 
echo "</select>"; 
} 
} 
?>