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

16 votes148 views2 answers
Php pass a variabele to js
PHP
2 votes153 views4 answers
Get acf repeater field
PHP
0 vote139 views1 answer
Cakephp group by count
PHP
1 vote193 views2 answers
Minecraft uuid generator
PHP
10 votes148 views2 answers
ForeignId in laravel
PHP
3 votes164 views2 answers
Library not loaded: /usr/local/opt/icu4c/lib/libicuio.64.dylib Referenced from: /usr/local/bin/php
PHP
0 vote145 views2 answers
Php send values in $_SESSION to other page
PHP
0 vote136 views1 answer
Laravel development serve doesn't stop
PHP
3 votes151 views2 answers
Laravel adding condition to relation
PHP
23 votes137 views6 answers
Convert to string php
PHP