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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to