Sorting by Date problem

[johnp813]

I am sorting by date, but the results are not accurate. Perhaps it is the date format i am using ?? It actually appears to be accurate as long as the year is the same. The date format I am using and saving to mysql is like: 11/10/2003

Here is sort code...

$query = "SELECT * FROM newstable WHERE status = 'Archived' ORDER BY date DESC ";

Anyone know why ??

If it is the format of the date I am using is there anyway to make it work Without changing the date format ??? That will require a lot of changes in a lot of places...

Any help and advise is Greatly appreciated...

[LordShryku]

It's doing that because your date field isn't actually a date field. You should be changing them to date type fields, but since this is such a burden, you could CAST it and DATE FORMAT it. Check the manual or those. Or you could sort the array in php.