From: rDubya <[EMAIL PROTECTED]>
My problem is that I have events dated for Sep 2007 and on, and yet
they all come up as being on Dec 7 to 9, 2006..  any ideas?


How about having MySQL only return the events you are interested in?

SELECT yourEventFields FROM theTable
TO_DAYS( theEventDate ) >= TO_DAYS( NOW() )
TO_DAYS( theEventDate ) <= TO_DAYS( NOW() ) + 21

I like theEventDate to be in the format YYYY-MM-DD

A place for moms to take a break!

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to