Any mistake with the below query? Why do i get a parse error?
$queryServicingTypeDisplay = "SELECT * from report where ServicingType='".$_GET['ServicingType']."' and AircraftType='".$_GET['AircraftType']."'"
<?php
if (isset($GET['ServicingType']))
{
echo "Search results for: <b>" .$GET['ServicingType']. "</b><br>";
//end highlight
$cntr = 1 ; //counter for the table columns
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#00FFFF>AirCraft Tail No.</td>
<td align=center bgcolor=#00FFFF>Airframe Hours</td>
<td align=center bgcolor=#00FFFF>Type of Defect</td>
<td align=center bgcolor=#00FFFF>Location of Defect</td>
<td align=center bgcolor=#00FFFF>Rectifications</td>
<td align=center bgcolor=#00FFFF>Comments</td>
<td align=center bgcolor=#00FFFF>Related Documents</td>
</tr><tr>";
$queryServicingTypeDisplay = "SELECT * from report where ServicingType='".$GET['ServicingType']."' and AircraftType='".$GET['AircraftType']."'"
//echo $queryAircraftTypeDisplay;
$resultServicingTypeDisplay = mysql_query($queryServicingTypeDisplay) or die ("couldn't execute query ".mysql_error());
while ($row = mysql_fetch_array($resultServicingTypeDisplay))
{
$aircraftTailNo = $row[ '1' ] ;
$aircraftType = $row[ '2' ] ;
$airFrameHours = $row[ '3' ] ;
$defectInfo = $row[ '4' ] ;
$rectifications = $row[ '5' ] ;
$comments = $row[ '6' ] ;
$relatedDoc = $row[ '7' ] ;
//if there are 7 cols, write the <tr> tag and reset the counter
if ($cntr == 2)
{
echo "</tr><tr>";
$cntr =1;
}
echo "
<td>$aircraftTailNo </td>
<td>$aircraftType </td>
<td>$airFrameHours </td>
<td>$defectInfo </td>
<td>$rectifications </td>
<td>$comments </td>
<td>$relatedDoc </td>
";
$cntr++; //increment the counter
}//end while
echo "</tr></table>";
}
?>
