How to get a last 5 Fights

[Gabriel Fernandez]

Hello People, i want get de last 5 flights with this iformations:

Flight No Departure Arrival Equipment Flight Time Submitted By Type Status

Status( Is rejectd or acepetd)

Thanks

[Guest lorathon]

Same as my other code just modified a bit

<?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>

<table>
  <thead>
    <tr>
      <th>Flight #</th>
      <th>Departure</th>
      <th>Arrival</th>
      <th>Aircraft</th>
      <th>Duration</th>
      <th>Pilot</th>
      <th>Flight Type</th>
      <th>Status</th>
    </tr>
   </thead>
   <tbody>

<?php

if(count($pireps) > 0)
{
 foreach ($pireps as $pirep)
 {
   $pilotinfo = PilotData::getPilotData($pirep->pilotid);
   $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid); 
   if($pirep->accepted == 0) { $status = "PENDING"; }
   else if($pirep->accepted == 1) { $status = "APPROVED"; }
   else { $status = "REJECTED"; }

   echo "<tr>";
   echo "<td>'.$pirep->code.$pirep->flighnum.'</td>";
   echo "<td>'.$pirep->depicao.'</td>";
   echo "<td>'.$pirep->arricao.'</td>";
   echo "<td>'.$pirep->aircraft.'</td>";
   echo "<td>'.$pirep->flighttime.'</td>";
   echo "<td>'.$pilotid.' '.$pilotinfo->firstname.' '.$pilotinfo->lastname.'</td>";
   echo "<td>'.$pirep->flighttype.'</th>";
   echo "<td>'.$status.'</td>";
   echo "</tr>";
 }
}
else
{
   echo "<tr><td>There are no recent flights!</td></tr>";
}
?>
  </tbody>
</table>