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 vote125 views0 answer
PHP
0 vote133 views1 answer
Laravel send ajax
PHP
1 vote181 views1 answer
Laravel http retry
PHP
0 vote142 views1 answer
Php into javascript
PHP
1 vote236 views1 answer
Transaction cakephp 2
PHP CakePHP
24 votes154 views3 answers
Difference of two dates in seconds php
PHP
0 vote172 views1 answer
How to get the root domain in laravel
PHP Laravel
0 vote138 views1 answer
Laravel delete controller still cached
PHP
3 votes97 views1 answer
Laravel foreach index
PHP
0 vote134 views2 answers
Sorry, This File Type Is Not Permitted for Security Reasons
PHP