Addressed to: <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from <[EMAIL PROTECTED]> Mon, 5 Mar 2001 14:10:28 -0600
>
> This is just a guess but wanted to take a shot at it.
>
> Something like
>
> SELECT EventID, EventName, EventDescription,
> EventStartDate, EventEndDate
> WHERE EventStartDate > CURRENT_DATE
> ORDER BY EventStartDate ASC
> LIMIT 5;
>
> How did I do?
Close, very close. I belive CURRENT_DATE is a MySQL function. MySQL
functions are identified by not having a space between the function name
and the required ( that makes it a function. If CURRENT_DATE is
actually a function (I use NOW() because it is shorter) then you need to
change the WHERE clause to:
WHERE EventStartDate > CURRENT_DATE()
If CURRENT_DATE() is not a valid function change it to:
WHERE EventStartDate > NOW()
Both assume that EventStartDate is a MySQL DATE, DATETIME or TIMESTAMP
value. If they are something else, this will not work. It should be
one of these types though!!!
Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
