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 vote181 views3 answers
Why are my css properties not being applied to php file
PHP
1 vote159 views1 answer
Prestashop get all products
PHP
6 votes306 views3 answers
Disable admin bar wordpress
PHP Wordpress
0 vote300 views1 answer
Laravel curl request
PHP
6 votes188 views1 answer
Laravel check collection not empty
PHP
0 vote204 views1 answer
Laravelda urlga requestlarni cheklash
PHP
0 vote241 views1 answer
Unable to create PsySH runtime directory
PHP
2 votes212 views3 answers
Ternary in php
PHP
0 vote214 views1 answer
Install laravel jetstream inertia js
PHP Laravel
0 vote182 views1 answer
How to get length of object in php
PHP