On Sun, 4 Aug 2002 17:30:31 +0200 "John Fishworld" <[EMAIL PROTECTED]> wrote:
Why not simply does the where clause like : for a whole month, here is july: WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7' For a specific day, here the current day WHERE t_event_date=NOW() That means you store date as date/timestamp/... field type. You do not specify your rdbm, but seems to be mysql ;). hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php