May I suggest:
SELECT date_format(date, '%d/%m/%Y') as mydate, title,
id, display FROM news ORDER BY date DESC
changing the alias of your formatted date to mydate, the raw value of
date is now available to order by.
- michael dykman
On 9/12/07, Ross Hulford <[EMAIL PROTECTED]> wrote:
> $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?
>
>
> Ta,
>
> R.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
- michael dykman
- [EMAIL PROTECTED]
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
