|
|
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
Navigation:
[Reply to this message]
|