MySQL Forums
Forum List  »  Newbie

Date Order help
Posted by: Fuzzyhaggis
Date: July 26, 2005 09:04AM

I'm teaching myself php/MYSQL by making an events list for the local are. I've got the table set up with a "datetime" type column called "daytime" and I want the php script to order the entries by the date and time (ascending). The code I'm using is...

$query="SELECT who,whoweb,day,month,date,time,DATE_FORMAT(daytime, '%W %D %M %Y, %l.%i%p') as daytimeform,venue,what FROM gigs ORDER BY 'daytime' ASC";

but's they're displayed in the order I entered them - not ordered by date. Any thoughts? I'm probably being a bit dim as I'm kinda new to this.

Options: ReplyQuote


Subject
Written By
Posted
Date Order help
July 26, 2005 09:04AM
July 26, 2005 12:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.