I suspect that your problem is that you are converting your date field to a
string before sorting. You shouldn't use the same name for the alias as you
do for the field. Try
$result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as
formatted_date, title,
id, display FROM news ORDER BY date DES
$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 wit
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:
> $resul