How to reverse fetch assoc in php

while($row = mysql_fetch_assoc($result)){
    $items[] = $row;
}

$items = array_reverse($items ,true);

foreach($items as $item){
   echo $item['time']." - ".$item['username']." - ".$item['message'];
}

//another option can be

$query = mysql_query("SELECT * FROM (
                      SELECT time, username, message
                      FROM messages ORDER BY time 
                      DESC LIMIT 10) result 
                      ORDER BY time ASC   
                    ");

Source: stackoverflow.com

Similar codes

2 votes329 views1 answer
Delete confirmation destroy laravel
PHP Laravel
5 votes347 views5 answers
Laravel where creation is today carbon
PHP
0 vote315 views4 answers
Sweetalert laravel
PHP
0 vote314 views1 answer
How to get favicon with Goutte php
PHP
0 vote335 views2 answers
Php wpdb foreach
PHP
2 votes292 views2 answers
Php strftime
PHP
0 vote307 views1 answer
How to add x-xss-protection header
PHP
0 vote331 views1 answer
Php if post exists
PHP
0 vote298 views1 answer
Laravel migrate test environment
PHP
4 votes307 views3 answers
Laravel collection split
PHP