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 vote296 views1 answer
Install laravel jetstream inertia js
PHP
14 votes300 views1 answer
Php full form
PHP
1 vote329 views1 answer
Laravel s3 presigned url
PHP Laravel
0 vote371 views1 answer
Laravel vreeze
PHP Laravel
8 votes291 views2 answers
Laravel Edit
PHP
15 votes296 views6 answers
Transaction laravel
PHP
1 vote307 views1 answer
Remove all post in wordpress by query
PHP
1 vote311 views2 answers
Laravel log to console
PHP
0 vote303 views1 answer
If request type is post
PHP
6 votes318 views2 answers
Php string cut first x characters
PHP