Re: ordering dates

[Philip Hallstrom]

> $result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title, 
> id, display FROM news ORDER BY date DESC ");
>
> I have the query above the problem is oders them like so
>
> 30/05/2007
> 29/07/2007
> 25/0/2007
>
>
> The order is taken by the first number. Is there any way to order them 
> properly without a timestamp?

You're ordering by "date" but previously you turn "date" into a string by 
calling date_format on it.  Change the "as date" to something else and 
then the ordering will be chronologically descending.  Like this:

SELECT date_format(date, '%d/%m/%Y') as formatted_date, title, id, display 
FROM news ORDER BY date DESC