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 vote249 views2 answers
Codeigniter 4 get method deprecated
PHP CodeIgniter
0 vote157 views1 answer
Docker compose php
PHP
0 vote170 views1 answer
Php set status code
PHP
0 vote241 views1 answer
Yii2 arraydataprovider
PHP Yii
10 votes196 views2 answers
Laravel collection toArray
PHP
0 vote147 views1 answer
Laravel request not returning errors
PHP
4 votes306 views5 answers
Codeigniter base_url
PHP CodeIgniter
1 vote153 views1 answer
To find out where your php.ini is located
PHP
0 vote164 views1 answer
Ubuntu add phpstorm to launcher
PHP
0 vote213 views1 answer
Lengthawarepaginator gives keys on page 2
PHP