Date Order help
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.
Subject
Written By
Posted
Date Order help
July 26, 2005 09:04AM
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.