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

0 vote202 views1 answer
Sitemap for php website
PHP
0 vote197 views1 answer
Default null migration laravel
PHP Laravel
0 vote166 views2 answers
Laravel restrict home route access
PHP Laravel
1 vote217 views2 answers
If null blade laravel
PHP
1 vote198 views1 answer
How to add properties to the request object
PHP
0 vote186 views1 answer
Laravel capsule schema datatime CURRENT_TIMESTAMP
PHP
1 vote210 views1 answer
Get request data in observer laravel
PHP Laravel
0 vote214 views1 answer
Wp varnish ip
PHP Wordpress
1 vote197 views1 answer
Enable extensions in php.ini
PHP
1 vote227 views2 answers
Laravel check if object empty
PHP Laravel