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

-3 votes184 views2 answers
How to set up alert messages in laravel 8
PHP Laravel
0 vote176 views1 answer
Response()->make laravel pdf
PHP Laravel
-1 vote150 views1 answer
Array marge in php
PHP
0 vote180 views1 answer
Wordpress fs_method direct
PHP Wordpress
0 vote239 views1 answer
Return single row from eloquent all collection laravel
PHP Laravel
0 vote156 views1 answer
Select randomly from mysqli php
PHP
0 vote152 views1 answer
Php artisan key:generate error
PHP
9 votes153 views3 answers
Pdo close connection
PHP
0 vote272 views1 answer
Drupal 8 entity query
PHP Drupal
0 vote171 views1 answer
Encryption key has not encrypted laravel
PHP Laravel