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

6 votes317 views1 answer
Debug query builder laravel
PHP
0 vote382 views2 answers
Obtener datos de usuario registrado en WordPress
PHP Wordpress
0 vote379 views1 answer
Orwherebetween laravel
PHP Laravel
1 vote451 views1 answer
Edit data using model in laravel 8
PHP Laravel
0 vote372 views4 answers
Laravel upload image
PHP
1 vote406 views2 answers
Get the current page id in wordpress
PHP Wordpress
0 vote347 views1 answer
How to add custom navigation menus in wordpress themes
PHP Wordpress
15 votes378 views6 answers
Confirm password validation in laravel
PHP Laravel
48 votes359 views5 answers
Laravel clear route cache
PHP
2 votes392 views1 answer
Multiple logical condition in laravel query
PHP Laravel