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

7 votes185 views5 answers
Laravel foreach loop index in controller
PHP Laravel
0 vote161 views1 answer
Unable to open file error in php
PHP
0 vote203 views2 answers
Curl post laravel
PHP Laravel
0 vote190 views1 answer
Php createFromFormat day of week
PHP
1 vote180 views1 answer
Laravel get last get request
PHP
9 votes202 views6 answers
Laravel logout
PHP Laravel
0 vote153 views1 answer
Tina4 save file to database in orm
PHP
3 votes214 views5 answers
How to create slug in laravel
PHP Laravel
0 vote194 views1 answer
Custom pagination laravel css
PHP Laravel
0 vote208 views1 answer
Laravel skip a loop if error
PHP Laravel