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

5 votes175 views1 answer
Why we use .htaccess file in php
PHP
1 vote140 views1 answer
Shorttime php
PHP
1 vote138 views1 answer
Default php program
PHP
0 vote153 views1 answer
Hide plugin update notification wordpress
PHP Wordpress
2 votes147 views1 answer
Redirect on validation error laravel to specific section laravel
PHP Laravel
12 votes135 views5 answers
Php post
PHP
0 vote195 views1 answer
Creating random number betwwen ranges in php
PHP
18 votes123 views4 answers
Create model view controller laravel
PHP
1 vote85 views2 answers
How to add bearer token in swagger laravel
PHP
2 votes126 views2 answers
Php if $_POST
PHP