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 vote128 views1 answer
Laravel @extends
PHP
0 vote142 views1 answer
Laravel translation parameter send
PHP Laravel
0 vote137 views1 answer
Laravel raw query join many to many
PHP
0 vote172 views1 answer
Php catch echo output
PHP
0 vote112 views1 answer
SSL PHP CURL
PHP
3 votes137 views1 answer
Wordpress get domain
PHP Wordpress
0 vote150 views1 answer
How to share count of things to sidebar in laravel
PHP
1 vote116 views1 answer
Php get all elements of array except last
PHP
1 vote115 views1 answer
Carbor sub day
PHP
1 vote162 views2 answers
Serialization of 'Symfony\Component\HttpFoundation\File\File' is not allowed
PHP