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 vote280 views1 answer
Php clean all output buffers
PHP
0 vote232 views1 answer
Prevent xss attack in laravel
PHP
7 votes273 views4 answers
Laravel route namespace and prefix
PHP Laravel
1 vote275 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
0 vote230 views1 answer
Phpspreadsheet set cell by column and row
PHP
9 votes224 views3 answers
Php variable as javascript function parameter in echo
PHP
1 vote269 views5 answers
Laravel eloquent batch insert
PHP Laravel
1 vote316 views1 answer
Twig symfony get route
PHP Symfony
10 votes233 views3 answers
Php define object
PHP
0 vote263 views1 answer
Populate old value of dropdown laravel
PHP Laravel