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 vote284 views2 answers
Laravel collection flatten
PHP
0 vote262 views1 answer
Laravel response download video laravel medialibrary
PHP
0 vote265 views1 answer
Symfony functional test clear session and cookies
PHP
7 votes267 views2 answers
Transaction commit rollback in laravel
PHP
1 vote263 views1 answer
How import the impliment countable php
PHP
0 vote284 views1 answer
Slidepay
PHP
4 votes290 views2 answers
Php array to console
PHP
4 votes304 views3 answers
Wp+get feature image
PHP
0 vote337 views1 answer
Laravel return view in web.php
PHP Laravel
5 votes258 views1 answer
Php heredoc
PHP