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 vote247 views1 answer
Pht get header from request
PHP
0 vote218 views2 answers
Laravel roles and permissions
PHP
0 vote159 views1 answer
Avg rating get in join in laravel 8
PHP
0 vote219 views1 answer
Limiter la révision des articles WordPress
PHP
0 vote200 views1 answer
Iqbal Laravel save record in two table in one line
PHP Laravel
1 vote165 views1 answer
Laravel unique title except id on edit
PHP
1 vote199 views2 answers
Laravel eloquent join two models
PHP
0 vote174 views1 answer
Get object tyhpe php
PHP
0 vote198 views1 answer
Laravel store blob image into database
PHP Laravel
3 votes151 views2 answers
Php set error log file
PHP