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

3 votes139 views1 answer
Wordpress wp_head
PHP Wordpress
1 vote114 views2 answers
Convert php to curl
PHP
8 votes118 views6 answers
Codeigniter echo last query
PHP
5 votes110 views3 answers
'mix' is not recognized as an internal or external command
PHP
2 votes129 views1 answer
Add id to route name in laravel blade
PHP Laravel
0 vote122 views1 answer
Item count in cart quantitiy woocommerce
PHP
9 votes166 views4 answers
Composer require laravel/ui laravel 7
PHP Laravel
0 vote119 views1 answer
Enable tab completion in terraform
PHP
1 vote187 views1 answer
Laravel mongodb delete
PHP Laravel
11 votes124 views6 answers
Redirect route with parameters laravel
PHP