ORDER BY date

[Anon]

Okay, I have a news page and I want to order the entries by date, newest at the top.

Anyways, I set up a auto date function to put the date onto new entries, and after getting over the shock of it actually worked thought maybe I can just set order by date, this is course didn't work as they are all in the format xx-xx-xx.

So, I have a solution just its an ugly slow one.
I set up the $day, $month, $year variables, in the form 19-12-00 for today, 19th December 2000 (UK format) and then assign each a number, for the date above $day gets 19, $month gets 12000, $year gets 999999999 or something, I can then order them by setting these to position, but its slow, ugly and I figured that surely, there must be some easier way? A built in function for example.

Any help appreciated!

Thanks

[Anon]

did you use mysql as db? if you did, and if you did use a mysql date or datetime column type for the date you describe, it should work

Matthias

[Anon]

I did use MySQL, its in the column date, hence "order by date"

Or is there someway of recording the time in a fashion that would allow me to order by date (but which would remain unchanged upon editing, which I can do easily for the date row, just don't update it when editing)

Thanks