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

0 vote161 views2 answers
Where are WordPress Pages and Posts Stored
PHP Wordpress
1 vote247 views2 answers
Magento2 zend log
PHP Zend
0 vote138 views1 answer
Open two files at once in phpstrom
PHP
0 vote141 views1 answer
Laravel delete index
PHP
0 vote153 views3 answers
Laravel query order by relation
PHP
1 vote144 views1 answer
Laravel artisan call with confirm
PHP
16 votes244 views4 answers
Wordpress debug mode enabled
PHP Wordpress
0 vote146 views1 answer
Downgrade php version vagrant
PHP
0 vote108 views1 answer
Create index for table mysql phpmyadmin
PHP
4 votes159 views2 answers
Auth guard (admin) is not defined laravel 8
PHP