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

9 votes280 views5 answers
How to extract data from json in php
PHP
5 votes253 views3 answers
Laravel model limit
PHP
17 votes258 views4 answers
WordPress debug
PHP
0 vote289 views1 answer
How to update all row in laravel
PHP Laravel
3 votes247 views1 answer
Php color echo
PHP
0 vote248 views1 answer
Disable update notification for individual plugins
PHP
0 vote264 views1 answer
Ajax pagination with search and filter in php
PHP
3 votes292 views2 answers
Laravel where condition on relationship
PHP Laravel
0 vote244 views1 answer
Use middleware in controller to have access session
PHP
1 vote257 views5 answers
Jobs laravel
PHP