Bluegrass Airlines Recent PIREPs
if (isset($HTTP_REFERER)) {
echo "Back";
} else {
echo "Back";
}
?>
PILOT# | NAME | Flight | Minutes | Aircraft | Date | COMMENTS
|
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$bgcolor = "white";
$query="SELECT * FROM pireps ORDER BY date DESC";
$result=mysql_query($query);
$num=mysql_numrows($result);
if ($num==0) {
echo "No Records Found
";
} else {
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$bga=mysql_result($result,$i,'bga');
$name=mysql_result($result,$i,"name");
$fromto=mysql_result($result,$i,"from-to");
$min=mysql_result($result,$i,"min");
$rawdate=mysql_result($result,$i,"date");
$aircraft=mysql_result($result,$i,'aircraft');
$comments=mysql_result($result,$i,"comments");
$date = date('j M y', $rawdate);
if(($comments=="Enter Comments Here.") OR ($comments=='') OR ($comments=='None')) {
$link="None";
} else {
$link="Comment";
}
?>
echo $bga; ?> | echo $name; ?> | echo $fromto; ?> | echo $min; ?> | echo $aircraft; ?> | echo $date; ?> | echo $link; ?> |