[Solved] Reverse order of array

[brianatlarge]

I’m trying to display posts in reverse order from newest to oldest. I’ve got the following array filled with timestamped dates:

I’m using array_reverse to try to flip the order, but it doesn’t seem to work:

Code:

Code:

Array
(
[0] => 2010-03-27 15:43:31
[1] => 2010-03-27 20:28:50
[2] => 2010-03-27 20:52:28
)
Array
(
[0] => 2010-03-27 15:43:31
[1] => 2010-03-27 20:28:50
[2] => 2010-03-27 20:52:28
)

Am I not doing this right?

[Argeaux]

How about this:

Code:

[brianatlarge]

That was it. Thanks.

[Irrorate]

I realise this was solved already, but wouldn’t it have been more efficient to sort the replies when executing the query?

Code:

SELECT * FROM posts ORDER BY timestamp DESC

That will select all the posts and order by the most recent timestamp (i.e. newest to oldest)?

[Author]

Posts