[RESOLVED] How to turn results up side down

[perrohunter]

hi.

Im getting some results from a mysql database and im using this query

SELECT * FROM news WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= create_date LIMIT 5

now, it do send me back the most recent 5 files but the problem is that it shows me first the oldest result and the newest go to the bottom :/

What can i do so the newest show at the top and not at the bottom ??

[subwayman]

SELECT * FROM news WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= create_date ORDER BY create_date ASC LIMIT 5

Default order is DESC (decending). ASC means order ascending.

[perrohunter]

Thx ! ! ! ! !