![]() ![]() ![]() ![]() ![]() |
| Flight Details |
Flight ID:
$server = "localhost";
$user = "phpAgent";
$pass = "log68in";
$tbl= "dSys";
$tmpConn = @mysql_connect($server,$user,$pass) or die ("Unable to connect to internaly specified server");
if($tmpConn) {
$gotAcDB = mysql_select_db($tbl , $tmpConn);
$tmpQry = "select * from flights left join pilots on picPtr=pID left join flightCats on category=fcID left join aircraft on acPtr=aID where fID=$recordID";
$tmpResult = mysql_query($tmpQry,$tmpConn);
/*---------------------------------------------------------------------------------------*/
/*--- fetch the rows and step through the results */
/*---------------------------------------------------------------------------------------*/
$tmpNumRows = mysql_num_rows($tmpResult);
for ($tmpCount == 0; $tmpCount < $tmpNumRows; $tmpCount++) {
list($fID,$filed,$state,$description,$depDate,$depTime,$depICAO,$arrDate,$arrTime,$arrICAO,$totalTime,$distance,$frules,$category,$landingTech,$landingState,$missStatus,$earnings,$extraCost,$acPtr,$burntFuel,$fuelCost,$acOpCost,$picPtr,$schedPtr,$acRem,$missRem,$pirepPtr,$depRW,$depWindKts,$depWindDir,$depRWX,$arrRW,$arrWindKts,$arrWindDir,$arrRWX,$sysFailures,$nodes,$paxnum,$paxcash,$cargocash,$pID,$skip,$nickname,$skip,$skip,$skip,$skip,$skip,$skip,$skip,$skip,$catname,$skip,$aID,$type,$tailno,$callsign)= mysql_fetch_row($tmpResult);
} /* end for $count */
/*---------------------------------------------------------------------------------------*/
/*--- write out the end of the select tag */
/*---------------------------------------------------------------------------------------*/
/*---------------------------------------------------------------------------------------*/
/*--- and close the connection. */
/*---------------------------------------------------------------------------------------*/
mysql_close($tmpConn);
} ELSE {
echo "Drats. No connection to database in place!";
} /* --- end if $conn --- */
?>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Filed: / State:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
[<<<] |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||