Posted by Jeff on 10/10/60 11:21

Hello,
I am trying to show events listed in a database table named
"LoungeEvents" for nightclub engagements. I want to display all events from
today forward. ignoring what happened yesterday. Event date is identified by
the field "EventDate". I have the sql I am using below. How do I filter the
sql to show only items in the present or future? I am formatting the date
for display. I am programming the pages with PHP.




"SELECT Event, EventComment, DATE_FORMAT(EventDate, '%W - %c.%d' ) AS
EventDate FROM LoungeEvents ORDER BY EventDate ASC"




Thanks in advance, Jeff

[Back to original message]