trouble with display of drop down results

NoobPHP

I can get the first two drop down list 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?

Initial Drop down list

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

<?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

<?php 
$queryAircraftType = "SELECT * report where aircrafttype='".$_GET['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>"; 
} 
}          

?>

dnast

Are the two dropdowns in separate forms? The only thing I could guess is that $_GET['AircraftType'] isn't set in the third portion of code. I was wondering why the second dropdown let's you choose a 'TailNo', but when you go to print the list you just go by the 'AircraftType'. Maybe there was a mix-up there?

If you uncomment that "echo $query" and it's displaying something, you should try pasting the query into phpMyAdmin or whatever you use. The rest of the code looks okay, so the problem must be in the query.

Also, you don't need extract() in there. It's not doing anything that you're using.

NoobPHP

Both the drop down lists were within a form.. The second drop down list is populated from the initial drop down.. and the displaying of results are shown after the selection of both drop down lists.. The thing is.. i couldn't get the results to be displayed after the second selection so i tried printing the results of the first drop down.. But none of them seems to work..

<?php
include("rsa.inc");
$connection = mysql_connect($host, $user, $password)
   or die ("couldn't connect to server.");
$db = mysql_select_db($database, $connection)
   or die ("couldn't select database.");


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

?>

<?
<form action="review.php" method="get" name="search">

Aircraft Type
<td width="56%"><select name="AircraftType" id="AircraftType">
<?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> <em><font color="#FF0000" size="2"></font></em></td>
</tr>
<tr> 
<td>Aircraft Tail No. (3 digit)</td>
<td width="56%"> 
<?php
if (isset($_GET['AircraftType']))
{
$queriesAircraftType = "SELECT AircraftTailNo FROM report where aircrafttype='".$_GET['AircraftType']."'";
$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>";
}
}
?>

<?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>";
}			
?>

dnast

Ah, I see.

So did the query string look okay when you echoed it? If so, did you try putting it into phpMyAdmin and seeing what results it gets? If it's getting results, then my only other guess is that something's wrong with the HTML code you're outputting and it's not being displayed in the browser, but does show up in the HTML source.

NoobPHP

Change from

<?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>";
}			
?>

to this

<?php  

$queryphpMyAdmin = "SELECT * report where aircrafttype='".$_GET['AircraftType']."'";
echo $queryphpMyAdmin;			
?>

But no results were displayed either.. So my guess is that the value wasn't parsed.. What should i do to get the results parsed or how should i confirm that value was parsed?