|
Date |
Instructor |
SFO |
Logger |
Tow Pilot |
Juniors |
$sqlOne = "Select Sched.Sched_date, Ops_Sched.Oid, Ops_Sched.SFO, Ops_Sched.Logger,
Inst.Inst, Tow.T1, Tow.T2, Tow.T3, Jun.J1, Jun.J2, Jun.J3
FROM Sched, Ops_Sched, Inst, Tow, Jun
WHERE Ops_Sched.Oid=Sched.Ops and Inst.Iid=Sched.Ops and Tow.Tid=Sched.Ops and Jun.Jid=Sched.Ops and Sched.Sched_date >= curdate()
ORDER by Sched.Sched_date";
//echo " Statement = $sqlOne ";
$DataBack = mysql_query($sqlOne);
$rc = 0;
while ( $myrow = mysql_fetch_array($DataBack))
{
$Date[$rc] = $myrow['Sched_date'];
$Instructor[$rc] = $myrow['Inst'];
$SFO[$rc] = $myrow['SFO'];
$Logger[$rc] = $myrow['Logger'];
$TP1[$rc] = $myrow['T1'];
$TP2[$rc] = $myrow['T2'];
$TP3[$rc] = $myrow['T3'];
$JU1[$rc] = $myrow['J1'];
$JU2[$rc] = $myrow['J2'];
$JU3[$rc] = $myrow['J3'];
echo "
$Date[$rc] |
$Instructor[$rc] |
$SFO[$rc] |
$Logger[$rc] |
$TP1[$rc] |
$JU1[$rc] | ";
if (($TP2[$rc] != '') || ($JU2[$rc] != ''))
{
echo "
|
$TP2[$rc] |
$JU2[$rc] | ";};
if (($TP3[$rc] != '') || ($JU3[$rc] != ''))
{
echo "
|
$TP3[$rc] |
$JU3[$rc] | ";};
++$rc ;};
?>
|
|