0) { $result = mysql_query("update lesc_aircraft set status='GROUNDED' where acid='".$acid."'"); } else { $result = mysql_query("update lesc_aircraft set status='CLEAR' where acid='".$acid."'"); } } function getAircraft() { $aircraft = array(); $result = mysql_query("select * from lesc_aircraft where active=1"); while ($row = mysql_fetch_assoc($result)) { $row['squawks'] = getSquawks($row['acid']); $aircraft[] = $row; } return $aircraft; } function getSquawks($acid) { $squawks = array(); $squawks['current'] = array(); $squawks['history'] = array(); $result = mysql_query("select * from lesc_squawk where acid='".$acid."' order by status desc, date desc"); while ($row = mysql_fetch_assoc($result)) { $row['logs'] = getSquawkLogs($row['sqid']); if ($row['status']==1) { $squawks['current'][] = $row; } else { $squawks['history'][] = $row; } } return $squawks; } function getSquawkLogs($sqid) { $logs = array(); $result = mysql_query("select * from lesc_squawk_log where sqid='".$sqid."' order by date desc"); while ($row = mysql_fetch_assoc($result)) { $logs[] = $row; } return $logs; } $ac = getAircraft(); /* header("content-type: text/plain"); print_r($ac); exit; */ ?> LESC Squawks
Logged in: "; foreach ($ac as $each) { $ac_status = $each['status']; if ($ac_status == 'CLEAR' && count($each['squawks']['current'])>0) { $ac_status = 'SQUAWKS'; } ?>
add squawk
• No Current Squawks"; } else { ?>
Current Squawks Comments  
opened by
by
close
comment
• No Squawk History"; } else { ?>
[+] Squawk History ()