reversing the order of a limited query I keep track of some documents for work, and have built an rss feed to
show the most recent 20. A simplified version of the query is here:
SELECT date_created, id, name
FROM documents
ORDER BY date_created desc
LIMIT 0, 20
This will show the most recent documents, with the most recent on the
top. Is it possible to reverse the order of these last twenty?
I'd like to have a list of the most recent documents, ordered ascending.
Thanks,
Charley |