| SCHEDULE

This is a list of the sectors for World Flight Australia 2007. To view more details of a particular flight, click the Flight number. To view flights from other years, use the links below.
include 'scheduleslinks.php'; ?>
All times and dates on this page are UTC (Zulu) TIME.
| Flight |
From |
To |
Departs |
Sched. Arrival |
Mins |
ETA / Actual |
Status |
//Start of PHP code for Flight information extraction
// Set DB parameters - (no user required on localhost)
//include the time conversion functions
include '../inc/dbconn.php';
include '../inc/dateconv.php';
include '../inc/timeconv.php';
$flightdata=mysql_query("SELECT flight, Origin, Dest, EDD, ETD, EDA, ETA, length, Status, firstprice, busprice, econprice, ActTD, OUTCO, DUTCO, ActDA, ActTA FROM flight WHERE (EDD like '%/07') ORDER BY flight") or die("Error accessing Flight information $flight");
//Display the result with a while loop
// this loop will iterate as many times as there are records
// and return an array named $flightdata
//now create the table elements
//set index counter so we can determine the line bg colours
$loopcount=1;
while (list($flight, $Origin, $Dest, $EDD, $ETD, $EDA, $ETA, $length, $Status, $firstprice, $busprice, $econprice, $ActTD, $OUTCO, $DUTCO, $ActDA, $ActTA) = mysql_fetch_row($flightdata))
{
if ($loopcount % 2 )
{
echo "";
}
else {
echo " ";
}
echo "| $flight | ";
echo "$Origin | ";
echo "$Dest | ";
list ($utctime, $utcdate) = timeconvert ( $ETD, $EDD, "1100");
echo "$utcdate $utctime | ";
list ($utctime, $utcdate) = timeconvert ( $ETA, $EDA, "1100");
echo "$utcdate $utctime | ";
echo "$length | ";
list ($utctime, $utcdate) = timeconvert ( $ActTA, $ActDA, "1100");
if ($ActDA!="")
{
echo "$utcdate $utctime | ";
}
else
{
echo " | ";
}
echo "$Status | ";
echo " ";
$loopcount++;
}
?>
include '../inc/pageend.php'; ?> |