function getFlightInfo($FID)
{
$connection = initDB();
$query;
if ($FID == 0) {
$query = "SELECT * FROM Flights";
} else {
$query = "SELECT * FROM Flights WHERE FID='" . $FID . "'";
}
$result = mysql_query($query);
// or die ("Query Failed ".mysql_error());
$flightData;
$flightID = 0;
while ($row = mysql_fetch_array($result)) {
$FID = $row['FID'];
$FName = $row['FName'];
$SourceSID = $row['SourceSID'];
$DestSID = $row['DestSID'];
$query2 = "SELECT * FROM Sectors WHERE SID='" . $SourceSID . "'";
$result2 = mysql_query($query2);
//or die ("Query Failed ".mysql_error());
$row2 = mysql_fetch_array($result2);
$source = $row2['Sector'];
$query3 = "SELECT * FROM Sectors WHERE SID='" . $DestSID . "'";
$result3 = mysql_query($query3);
//or die ("Query Failed ".mysql_error());
$row3 = mysql_fetch_array($result3);
$dest = $row3['Sector'];
//Build the Flight object
$flight = new Flight();
$flight->set_FID($FID);
$flight->set_FName($FName);
$flight->set_source($source);
$flight->set_dest($dest);
//Build the Flight object array
$flightData[$flightID] = $flight;
$flightID = $flightID + 1;
}
closeDB($connection);
return $flightData;
}
