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

-1 vote124 views1 answer
Check request method laravel
PHP
1 vote164 views1 answer
Php turney if
PHP
1 vote178 views2 answers
Running laravel as host
PHP Laravel
1 vote177 views2 answers
How to display data from mysql database into html table using php
PHP
0 vote153 views1 answer
String replace backslash php \\ \
PHP
2 votes185 views1 answer
Laravel blade file naming conventine
PHP
3 votes155 views2 answers
Laravel where condition on relationship
PHP
0 vote161 views1 answer
Laravel query with optional filter
PHP Laravel
1 vote153 views2 answers
Phpmailer addAttachment
PHP
0 vote174 views1 answer
Php class comment
PHP