Re: Dates in MYSQL

Tried the following as suggested - Still no dates showing $query = ' SELECT id, eventheading, DATE_FORMAT("eventdate", "%D %M %Y")as "evdt" FROM notices WHERE TO_DAYS(eventdate) >= TO_DAYS(now()) order by eventdate'; $result=mysql_db_query($dbname, $query, $link); if (!$result) { echo( mysql_error()); } else while ($row = mysql_fetch_array($result)) $entername = $row[entername]; $eventdate = $row[evdt]; $eventheading = $row[eventheading]; $id = $row[id]; Database table "notices" as follows id int NULL autoincrement entername text NOT NULL enterdate text NOT NULL eventdate text NOT NULL eventheading text NOT NULL eventbody text NOT NULL -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 afrancis@camerondesign.co.uk http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged information. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. Dl Neil <PHPml@DandE.HomeChoice.co.uk> wrote in message news:0b8401c1e62e$03072ad0$0600a8c0@jrbrown... > 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 >