php reverse order of fetched array

Question

I have very basic php question. I am fetching data from database and printing them with some styling row by row. The problem is that these data represent news and I would like them to be printed in reverse order (the last row I fetch should be printed first). I am not sure if I can fetch the whole table at once and them apply the reverse function (I tried it but it didnt work).

Here is my code:

<?php
                include 'dbconnect.php';
                $data = mysql_query("SELECT * FROM news") or die(mysql_error()); 

                while($info = mysql_fetch_array( $data )) 
                {
                echo '<article><h3> '.$info['subject'].'</h3><div id="date">'.$info['date']. '</div>';
                echo '<p>'.$info['news']. '</p></article>';

                } 
?>

I tried something like this:

$data = [];
array_push($array, $info);

inside the while loop and then printing it but it didnt turn out to work. Thanks for any answer!

How about array_reverse? php.net/manual/en/function.array-reverse.php — qooplmao
– qooplmao, Commented Mar 25, 2013 at 14:40

jeroen · Accepted Answer · 2013-03-25 14:41:09Z

3

You should to that directly in sql and not afterwards in php:

SELECT * FROM news ORDER BY date DESC

You should also switch to PDO (or mysqli) as the mysql_* functions are deprecated.

answered Mar 25, 2013 at 14:41

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daanvn · Accepted Answer · 2013-03-25 14:42:11Z

2

Try this:

$data = mysql_query("SELECT * FROM news ORDER BY date DESC") or die(mysql_error());

answered Mar 25, 2013 at 14:42

Daanvn

1,2666 gold badges27 silver badges42 bronze badges

1 Comment

symcbean Over a year ago

It fixes the ordering, but 'SELECT *' is a very bad practice. While it the code may seem to work with mysql_fetch_assoc(), using it with mysql_fetch_array() is downright silly.

Patrick Manser · Accepted Answer · 2013-03-25 14:41:28Z

2

"SELECT * FROM news ORDER BY id DESC"

You can use this, if you have an ID for every news.

answered Mar 25, 2013 at 14:41

Patrick Manser

1,1832 gold badges12 silver badges32 bronze badges

Comments

Alexey · Accepted Answer · 2013-03-25 14:41:01Z

0

array_reverse() function of PHP or ORDER BYid(or time/date column) DESC in mysql query

answered Mar 25, 2013 at 14:41

Alexey

3,4847 gold badges32 silver badges47 bronze badges

Comments

RyPope · Accepted Answer · 2013-03-25 14:42:51Z

0

mysql_query("SELECT * FROM news ORDER BY date DESC")

I believe that is what you are looking for.

answered Mar 25, 2013 at 14:42

RyPope

2,75531 silver badges53 bronze badges

Comments

QArea · Accepted Answer · 2013-03-27 08:44:33Z

0

$query = "SELECT * FROM news ORDER BY date DESC";
$data = mysql_query($query) or die(mysql_error());

answered Mar 27, 2013 at 8:44

QArea

5,0231 gold badge16 silver badges23 bronze badges

Collectives™ on Stack Overflow

php reverse order of fetched array

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related