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

Reply via email to