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 vote104 views1 answer
Laravel run query migration
PHP
-1 vote145 views4 answers
How to include file in laravel blade
PHP
8 votes106 views6 answers
Php isset
PHP
1 vote140 views1 answer
How to take last entry in database in laravel Method ONe
PHP Laravel
1 vote142 views1 answer
Laravel date rule before 18 years ago
PHP Laravel
1 vote133 views1 answer
Datediff in hour query builder laravel
PHP Laravel
0 vote117 views1 answer
Laravel mix disable notifications
PHP
22 votes120 views5 answers
Update or insert in laravel
PHP
8 votes99 views2 answers
Laravel drop multiple columns
PHP
0 vote137 views1 answer
Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
PHP Laravel