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 vote117 views1 answer
Date format in laravel month name day name
PHP
4 votes113 views5 answers
Repeater acf
PHP
0 vote103 views1 answer
Php get all function arguments
PHP
15 votes137 views1 answer
Laravel composer install ignore
PHP Laravel
3 votes112 views2 answers
Delete route method in laravel
PHP
0 vote125 views1 answer
Multe data on database laravel
PHP Laravel
0 vote118 views1 answer
Remove invalid characters from a string laravel
PHP Laravel
0 vote132 views2 answers
Http://www.finalclap.com/faq/81-php-afficher-date-heure-francais
PHP
1 vote122 views1 answer
Rerun migration and seed
PHP
0 vote141 views4 answers
How to host laravel project on local server
PHP Laravel