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 vote373 views1 answer
Wordpress show notice only on plugin page
PHP Wordpress
0 vote371 views1 answer
Laravel 8 crud api example
PHP Laravel
0 vote306 views1 answer
Eloquent ORM means
PHP
0 vote314 views1 answer
Id type laravel
PHP
7 votes334 views6 answers
Sort laravel eloquent
PHP
20 votes376 views4 answers
Php all date formats
PHP
0 vote336 views1 answer
Get first cat php wp
PHP
0 vote406 views1 answer
Laravel access request in provider
PHP
4 votes279 views3 answers
Collection empty laravel
PHP
2 votes406 views6 answers
Redirect http to https htaccess
PHP