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

0 vote259 views1 answer
E_notice in php
PHP
1 vote304 views1 answer
How to pass data to controller in laravel
PHP Laravel
0 vote270 views1 answer
Php storage link
PHP
0 vote262 views2 answers
Wp menu declaration
PHP
3 votes302 views2 answers
Laravel carbon created_at date in current month
PHP Laravel
13 votes241 views2 answers
If condition in php
PHP
0 vote246 views1 answer
How to validate email or phone number single parameter request in laravel
PHP
8 votes252 views6 answers
Add days to date in PHP
PHP
1 vote231 views1 answer
Php has constant
PHP
0 vote253 views1 answer
PHP 2-Dimentional array
PHP