Re: Dates in MYSQL

Hi Alex, > Got my select statement to work as follows: > $query = ' SELECT * FROM notices WHERE TO_DAYS(eventdate) >= TO_DAYS(now()) > order by eventdate'; =well done! However the TO-DAYS calls do seem a bit OTT. Please post the schema for tbl:notices - specifically the datatype for eventdate. > Now trying to get the date more user friendly and tried: > > $query = ' SELECT id, eventheading, DATE_FORMAT("eventdate", "%D %M %Y")FROM > notices WHERE TO_DAYS(eventdate) >= TO_DAYS(now()) order by eventdate'; ... > When I echo ($eventdate) I get nothing. Not even an error. The problem is that $eventdate = "$row[eventdate]"; (which doesn't need the " around the whole of the RHS (some would put them around eventdate), BTW) doesn't tie up with: DATE_FORMAT("eventdate", "%D %M %Y") Recommend you change them to: DATE_FORMAT("eventdate", "%D %M %Y") AS evdt and $eventdate = $row[evdt]; See how the SQL and PHP tie together? Now you need to reconsider the other $row[] assignments. =Keep it coming! =dn