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

2 votes271 views2 answers
Show uploaded image in php
PHP
0 vote263 views1 answer
Cara membuat looping table dengan php
PHP
21 votes272 views2 answers
Php unset by value
PHP
-2 votes358 views2 answers
Why we use pusher in laravel
PHP Laravel
9 votes284 views4 answers
Php check if string ends with
PHP
0 vote326 views1 answer
Orwhere in wherehas laravel
PHP Laravel
0 vote328 views1 answer
Check if data inserted in database wordpress plugin
PHP Wordpress
1 vote258 views1 answer
Stack once laravel
PHP
0 vote262 views1 answer
How use same method in another class in laravel
PHP
7 votes255 views6 answers
Datetime to string php
PHP