Limit While Loop

[adamrifau]

how can i limit the data (display only last 10 )that display in this while loop

 

$name = $userdata[1];
$attendance = $zk->getAttendance();
sleep(1);
while(list($idx, $attendancedata ) = each($attendance)):
if ( $attendancedata[2] == 1 )
$status = 'Check Out';
else
$status = 'Check In';
?>
  <tr>
                <td><?php echo $idx ?></td>
                <td><?php echo $attendancedata[0] ?></td>
                <td><?php echo $name ?></td>
                <td><?php echo $attendancedata[1] ?></td>
                <td><?php echo $status ?></td>
                <td><?php echo date( "d-m-Y", strtotime( $attendancedata[3] ) ) ?></td>
                <td><?php echo date( "H:i:s", strtotime( $attendancedata[3] ) ) ?></td>
            </tr>

 

 

Edited September 17, 2016 by adamrifau

[PravinS]

It will be better if you use ORDER BY DESC and LIMIT 10 in SELECT query, which will give you last 10 records in descending order.

 

Or you can use pagination, by which you can devide records(10 records) per page.

[ginerjm]

Didn't you get this answer in your post on another forum?

[cyberRobot]

For what it's worth, there were a few posts to this question yesterday. But it looks like those were lost when the forum was rolled back to IPB v3. I believe they suggested the LIMIT clause and array_slice().

Edited September 22, 2016 by cyberRobot