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 vote283 views1 answer
Php top frameworks
PHP
1 vote252 views1 answer
Default php program
PHP
0 vote285 views1 answer
How to read laravel query string with dash
PHP
1 vote358 views1 answer
Laravel include with variable
PHP Laravel
0 vote281 views1 answer
Laravel maintenance mode custom class
PHP
0 vote302 views1 answer
Laravel return view in web.php
PHP
27 votes268 views4 answers
How to color php text
PHP
1 vote340 views1 answer
Laravel php artisan make:controller in subfolder
PHP Laravel
1 vote280 views1 answer
Invalid datetime format 1292
PHP
2 votes301 views2 answers
Validate password laravel
PHP