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 vote112 views1 answer
Open php tag
PHP
0 vote99 views1 answer
Php array current
PHP
0 vote113 views1 answer
Laravel get all users except role spatie
PHP Laravel
0 vote104 views1 answer
Php git pull webhook
PHP
2 votes128 views1 answer
Read global laravel request()
PHP Laravel
0 vote105 views1 answer
Laravel: Unknown: Failed opening required 'server.php' (include_path='php\PEAR
PHP
0 vote94 views1 answer
Filtering Eloquent collection data with filter
PHP
0 vote105 views1 answer
Laravel catch TokenMismatchException
PHP
-1 vote62 views1 answer
Strcasecmp in php
PHP
0 vote103 views1 answer
Insert views laravel database
PHP