Order By Date

[JoeAtRevolutionUnltd]

I am trying to set up a page for a band that will display the next show first followed by the next date and so on. Here is my sql that isn't working properly.

$shows = mysql_query("SELECT date_format(date, '%a, %b %D, %Y') as date, venue, location, state, bands, start_time, cover, age
FROM shows
WHERE date >= sysdate()
ORDER BY date DESC");

Any ideas how to make this work?

Thanks.

 

[guelphdad]

when you are formatting your date for output, give it a different alias name and then still order by date.