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 views1 answer
Ternaire echo isset php
PHP
14 votes182 views4 answers
Php get current domain
PHP
4 votes181 views1 answer
500 error php
PHP
0 vote223 views2 answers
Csv utf-8 excel into php
PHP
8 votes188 views2 answers
How to install a specific version of package using Composer?
PHP
0 vote191 views1 answer
Contact form 7 remove p
PHP
3 votes183 views3 answers
Long day in php
PHP
4 votes183 views1 answer
Print beauty php
PHP
0 vote206 views1 answer
Phpunit-watcher
PHP
1 vote199 views1 answer
Get request data in observer laravel
PHP Laravel