MySQL: ORDER BY in conjuntion with DATE FIELDS

[Daggeth]

Eh, I'm programming a PHP script with dates and I need to order by Nearest date to Farthest away date. If I just use ORDER BY in conjuntion with SELECT, it gives me the farthest away date first, I need the order reversed.

How can I accomplish this?

[dnszero]

Use the DESC modifier, like so:

SELECT * FROM yourdatabase ORDER BY yourfield DESC;