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

8 votes241 views5 answers
Redirect in codeigniter
PHP CodeIgniter
0 vote175 views1 answer
How can we check in the table in comma separated values in laravel
PHP
3 votes232 views5 answers
Xampp
PHP
0 vote175 views1 answer
Pegar porcentagem de um valor php
PHP
2 votes212 views2 answers
How uninstall the laravel
PHP Laravel
0 vote185 views1 answer
Php heredoc variable substitution
PHP
2 votes160 views1 answer
End session variable php
PHP
0 vote174 views1 answer
Execcommand insert video
PHP
1 vote177 views1 answer
Wp_list_custom_post type
PHP
0 vote182 views1 answer
Test if php is installed
PHP