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 vote204 views1 answer
How to get private images in s3 laravel
PHP
0 vote225 views2 answers
Laravel return new tab
PHP Laravel
0 vote213 views1 answer
Publish Spatie Laravel Permission
PHP
0 vote208 views1 answer
Day of Week Using carbon library
PHP
27 votes216 views4 answers
Common array methods php
PHP
0 vote198 views1 answer
Send multiple db notification same function in laravel
PHP
12 votes220 views5 answers
Drop column migration laravel
PHP Laravel
0 vote214 views2 answers
Php xml to json
PHP
0 vote167 views0 answer
PHP
1 vote255 views1 answer
Laravel php artisan make:controller in subfolder
PHP Laravel