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 vote350 views1 answer
Php file_get_contents html with special characters
PHP
8 votes393 views1 answer
Add sucssess message laravel
PHP Laravel
14 votes311 views3 answers
How to convert string to int in php laravel
PHP
5 votes335 views2 answers
Php copy
PHP
0 vote323 views1 answer
Laravel set innodb scema builder
PHP
4 votes360 views2 answers
Php get list of filenames in diretory
PHP
0 vote323 views1 answer
Supress warning php
PHP
2 votes311 views2 answers
Php select page change
PHP
0 vote351 views1 answer
Rename matomo php
PHP
18 votes333 views5 answers
Php list directories
PHP