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 vote91 views1 answer
Php select disable submit no value
PHP
5 votes89 views4 answers
Php get time in milliseconds
PHP
0 vote189 views1 answer
How to filter the all special characters in cakephp from an array
PHP CakePHP
20 votes87 views6 answers
Create model laravel
PHP
15 votes123 views2 answers
Error: Cannot find module 'webpack/lib/rules/DescriptionDataMatcherRulePlugin
PHP
2 votes106 views2 answers
Number of week days between two dates in php
PHP
0 vote114 views1 answer
View blob phpmyadmin
PHP
0 vote115 views1 answer
Php set charset utf 8
PHP
0 vote114 views1 answer
Laravel unknown column updated at
PHP Laravel
1 vote109 views1 answer
How to store an image in laravel directly from url
PHP