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 vote230 views3 answers
Laravel override factory values in database seeder
PHP Laravel
0 vote197 views1 answer
Image_lib codeigniter add _thumb
PHP
0 vote222 views1 answer
Create new controller laravel with model binding
PHP
19 votes199 views6 answers
Laravel updateOrCreate
PHP Laravel
2 votes232 views5 answers
Php mailer
PHP
9 votes209 views1 answer
Wp-config change url wp-config
PHP
6 votes217 views6 answers
Search query in laravel
PHP Laravel
36 votes212 views6 answers
Strtolower php
PHP
0 vote209 views1 answer
Laravelstart project
PHP
0 vote183 views1 answer
Laravel migrate patth
PHP Laravel