On Sun, 4 Aug 2002 17:42:17 +0200 Pierre-Alain Joye <[EMAIL PROTECTED]> wrote:
> On Sun, 4 Aug 2002 17:30:31 +0200 > "John Fishworld" <[EMAIL PROTECTED]> wrote: > For a specific day, here the current day WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW()) if you store as date-time format :). hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php