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

3 votes311 views3 answers
Laravel clear table
PHP Laravel
0 vote250 views1 answer
Avoid grouping databases in phpmyadmin
PHP
0 vote280 views2 answers
How to remove duplicate values from an array in php
PHP
0 vote281 views1 answer
Php increment sum
PHP
0 vote241 views1 answer
How we show full name of month in posts
PHP
0 vote240 views1 answer
Replace key name in associative array
PHP
2 votes232 views3 answers
Laravel migration drop foreign keys
PHP
0 vote233 views1 answer
API calling
PHP
0 vote278 views1 answer
Create a exporter in laravel command
PHP Laravel
0 vote266 views1 answer
Date day 7 day in increase in laravel
PHP Laravel