[NoobPHP]

I can get the first two drop down list(within a form) to work, now the thing is i can't get it to display the results in table after the selections of the drop down lists.. that is to say after the user select the value from the drop down lists.. it should display results onto the table.. How should i do it anyone know?

// 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);

Initial Drop down list

<select name="AircraftType" id="AircraftType" onchange="form.submit();">
<?php while($rowAircraftType = mysql_fetch_array($resultAircraftType)) { 
if($rowAircraftType['AircraftType']==$_GET['AircraftType'])
{ 
echo "<option selected value='$rowAircraftType[AircraftType]'>$rowAircraftType[AircraftType]</option>"."<BR>";} 
else
{ echo "<option value='$rowAircraftType[AircraftType]'>$rowAircraftType[AircraftType]</option>";} 
} 
?> ÂÂ*	
 ÂÂ* ÂÂ* ÂÂ* ÂÂ* ÂÂ* ÂÂ* ÂÂ*</select>

second drop down list populated from initial drop down

<?php
if (isset($_GET['AircraftType']))
{
$queriesAircraftType = "SELECT AircraftTailNo FROM report where aircrafttype='".$_GET['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>";
}
}
?>

Display results within table

<?php ÂÂ* ÂÂ*
$queryAircraftTypeDisplay = "SELECT * from report where aircraftTailNo='".$_GET['AircraftTailNo']."'";
echo $queryAircraftTypeDisplay;
$resultAircraftTypeDisplay = mysql_query($queryAircraftTypeDisplay) or die ("couldn't execute query ".mysql_error());
while ($row = mysql_fetch_array($resultAircraftTypeDisplay))
{
extract($row);
echo "<tr>
<td>$_GET[AircraftTailNo]</td> 
<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>";
} ÂÂ*	
?>