PHP Code:
<b><a class="aPara">Outbound:</a></b>
<div class="divOutbound">
<table width="100%" class="resultsTable" align="center">
<tr>
<th><u>Airline</u></th>
<th><u>Departure Airport</u></th>
<th><u>Departure Date</u></th>
<th><u>Departure Time</u></th>
<th><u>Arrival Airport</u></th>
<th><u>Arrival Date</u></th>
<th><u>Arrival Time</u></th>
<th><u>Fare</u></th>
<th><u>Choice</u></th>
</tr>
<tr>
<?php
#if connection does not work use PEAR
include("database.php");
$flight_tab="flight";
$hotel_tab="hotel";
$outDate=$_REQUEST["flightDateDep"];
$inDate=$_REQUEST["flightDateRet"];
$depAir=$_REQUEST["airportDeparture"];
$arrAir=$_REQUEST["airportArrival"];
$selSQL="SELECT * FROM flight WHERE DepartureAirport='$depAir' AND DestinationAirport='$arrAir' AND DepartureDate='$outDate'";
$resSQL=mysql_query($selSQL, $myconn2) or die(mysql_errno().':'.mysql_error());;
while($row=mysql_fetch_array($resSQL)){
echo '<tr>
<td class="cell" align="center" height="19"><input type="hidden" name="OAir" value=""/>'.$row["Airline"].'</td>
<td class="cell" align="center" height="19"><input type="hidden" name="ODepAir" value=""/>'.$row["DepartureAirport"].'</td>
<td class="cell" align="center" height="19"><input type="hidden" name="ODepDate" value=""/>'.$row["DepartureDate"].'</td>
<td class="cell" align="center" height="19"><input type="hidden" name="ODepTime" value=""/>'.$row["DepartureTime"].'</td>
<td class="cell" align="center" height="19"><input type="hidden" name="OArrAir" value=""/>'.$row["DestinationAirport"].'</td>
<td class="cell" align="center" height="19"><input type="hidden" name="OArrDate" value=""/>'.$row["ArrivalDate"].'</td>
<td class="cell" align="center" height="19"><input type="hidden" name="OArrTime" value=""/>'.$row["ArrivalTime"].'</td>
<td class="cell" align="center" height="19"><input type="hidden" name="OFare" value=""/>£ '.$row["Fare"].'</td>
<td class="cell" align="center" height="19"><input type="checkbox" name="cboxFlight" id="cboxFlight"/></td>
</tr>';
}
?>
<td colspan="9" align="center">
<p class="errorText">Please Select Your Outbound Flights</p>
</td>
</tr>
</table>
</div>