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 vote179 views2 answers
Insert multiple rows laravel
PHP
4 votes248 views2 answers
Php loop through start and end date
PHP
0 vote259 views1 answer
Laravel api cors localhost issue
PHP Laravel
0 vote162 views1 answer
Wordpress get tagline
PHP Wordpress
6 votes188 views1 answer
Laravel check collection not empty
PHP
0 vote228 views1 answer
Double in migration laravel
PHP Laravel
-1 vote191 views1 answer
Turn error log WP
PHP
0 vote185 views1 answer
Phpoffice create excel and download
PHP
15 votes182 views1 answer
It is missing from your system. Install or enable PHP's pcntl
PHP
42 votes219 views5 answers
Create controller laravel with model
PHP Laravel