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 vote325 views1 answer
Saleor meaning
PHP
8 votes334 views3 answers
Laravel model::query
PHP Laravel
1 vote387 views3 answers
Laravel get url segment
PHP Laravel
-1 vote359 views1 answer
Wordpress turn off php warnings
PHP Wordpress
6 votes342 views3 answers
Laravel passport login with username
PHP
0 vote373 views1 answer
Unnamed place placeholders pdo
PHP
1 vote323 views1 answer
Laravel failed jobs retry
PHP
3 votes338 views2 answers
Refresh seeder laravel
PHP
1 vote308 views2 answers
Wordpress get option value
PHP
1 vote390 views1 answer
Laravel trans with parameters
PHP Laravel