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 vote306 views1 answer
Numeros positivos input laravel
PHP
0 vote304 views2 answers
Php set 404 page
PHP
16 votes449 views4 answers
Wordpress debug mode enabled
PHP Wordpress
0 vote296 views1 answer
Firebase push notification for web app step by step in php
PHP
12 votes316 views4 answers
Laravel get second last record
PHP
3 votes317 views6 answers
Php remove value from array if exists
PHP
0 vote300 views1 answer
How pass optional route parameter in laravel
PHP
6 votes304 views3 answers
Get term id by post id
PHP
-1 vote342 views1 answer
How to check if there is an authenticated user laravel
PHP Laravel
1 vote287 views1 answer
How get the latest data in database in laravel
PHP