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

1 vote118 views1 answer
How to alias table name in laravel model
PHP
0 vote142 views2 answers
Option value selected in laravel blade
PHP Laravel
3 votes123 views3 answers
Woocommerce order item get product id
PHP
1 vote126 views1 answer
How to take last entry in database in laravel Method ONe
PHP
1 vote184 views6 answers
Php loop through object
PHP
0 vote128 views1 answer
Php empy a file
PHP
0 vote163 views1 answer
Codeigniter select where
PHP CodeIgniter
2 votes128 views1 answer
Google my business listing
PHP
0 vote119 views1 answer
Php date modify plus 1 day
PHP
4 votes240 views5 answers
Codeigniter base_url
PHP CodeIgniter