[Resolved] Mysql listing by date

[fean0r]

I've got mysql listing by date which is fine expect I want the most recent date to appear at the top rather than at the bottom!

any ideas?

$query_items = "SELECT  *  FROM news ORDER BY date";

[HalfaBee]

Try this
$query_items = "SELECT * FROM news ORDER BY date DESC";

HalfaBee

[fean0r]

Thanks worked a treat!