[evalphp]

// PLACES DATABASE CONNECTION INFO IN THE VARIABLE –> $db
// FSE SERVICE KEY IS PASSED AS VARIABLE –> $skey
include(“wp-content/fsnsec.php”);
$db = $con;

date_default_timezone_set(‘America/New_York’);

echo “

Rally Pilots

---

“;

// TABLE HEADER
echo ‘

‘;
echo “

“;
echo ‘

‘;

// GET DATABASE ENTRIES
$ACroute = mysqli_query($db, “SELECT * from rally_pilots where Active like ‘Yes'”) or die(mysqli_error($db));

while ($row = mysqli_fetch_array($ACroute))
{

// GET AIRCRAFT
$ACreg = $row[“ACreg”];
$thisPilot = $row[‘fseName’];

$getChk = mysqli_query($db, “select Aircraft from rally_flights where ACreg = ‘$ACreg’ limit 1”) or die(mysqli_error($db));
$ro3 = mysqli_fetch_array($getChk);
$Aircraft = $ro3[“Aircraft”];
if ($Aircraft == “”) { $Aircraft = “No Rally Flights Found“; }

/* OFF FOR PILOT INFO TABLE
//$thisReg = $row[‘ACreg’];
//echo “Registered Pilot: “.$thisPilot.” || Registered Aircraft: “.$thisReg.”
“;

// GET AIRPORTS VISITED
$APvis = mysqli_query($db, “SELECT FromAP, ToAP from rally_flights WHERE Pilot = ‘$thisPilot'”) or die(mysqli_error($db));
$APlist = “”;
$num_vis = 0;

while ($ro2 = mysqli_fetch_array($APvis))
{

if ($num_vis == 0) { $APlist = $ro2[‘FromAP’]; }
$APlist = $APlist.” “.$ro2[‘ToAP’];
$num_vis +=1;

}

$thisMap = ‘MAP‘;
** OFF FOR PILOT INFO TABLE */

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
//echo ‘

‘;
//echo ‘

‘;
//echo ‘

‘;
//echo ‘

‘;

}

echo ‘

Pilot	Aircraft	Registration
‘.$row[“fseName”].’	‘.$Aircraft.’	‘.$ACreg.’
‘.$row[“chkPnt”].’	‘.$row[“ralTot”].’	‘.$row[“Active”].’
‘.$thisMap.’

‘;

[/evalphp]