markyboy123 Posted November 16, 2014 Report Share Posted November 16, 2014 Hi there, i have been on this forum to see if i can get code to have "upcoming arrivals" , the table shows but nothing appears in the table even tho i am flying. The code i am using is this: ?php $query = "SELECT * FROM phpvms_schedules ORDER BY arrtime + 0 ASC"; $list = DB::get_results($query); echo '<h3><span style="font-family:open sans; font-style:italic"><font color="#116ed8">Upcoming</font><font color="#18487f">Arrivals</font></span> - Current Time is '.date('G:i').'</h3>'; echo '<table width="100%" border="1">'; echo '<tr><td>Departure</td><td>Arrival</td><td>Arrival Time</td><td>Aircraft</td><td>Status</td></tr>'; $count = 0; { if(($flight->arrtime + 0) > date('G:i')) { if($count < 5) { $aircraft = OperationsData::getAircraftInfo($flight->aircraft); echo '<tr><td>'.$flight->depicao.'</td><td>'.$flight->arricao.'</td><td>'.$flight->arrtime.'</td><td>'.$aircraft->fullname.'</td>'; echo '<td>'; if(($flight->arrtime - date('G:i')) <= 1) { echo 'Arriving Soon'; } else { echo 'In Flight'; } echo '</td></tr>'; $count++; } } } echo '</table>'; ?> I am new to php but i just can't figure it out, i am using the free kacars for now but will be paying for the custom one soon, Any help will be very much appreciated Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.