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 vote224 views2 answers
How to delete image from aws using laravel 8
PHP Laravel
31 votes225 views3 answers
Carbon laravel use
PHP
0 vote181 views1 answer
How to stop message of laravel mix
PHP
0 vote198 views2 answers
Start/php>2
PHP
0 vote218 views1 answer
Php redirect if not logged in
PHP
2 votes166 views1 answer
Laravel check if session variable exists
PHP
2 votes171 views1 answer
Laravel catch exception ex log save
PHP
1 vote243 views1 answer
Php header redirect with parameters
PHP
7 votes217 views2 answers
Php one line if without else
PHP
0 vote207 views1 answer
Php count occurrences of string in array
PHP