Mysql query

[email protected]
Newsgroups php.db
Message-ID <63678.173.206.88.191.1260745253.squirrel@www.theverseoftheday.info>
Does anyone see anything wrong with this query?  Do I have one of the >, =
or < mixed up?  The purpose is to figure out if it is within 14 days of
Christmas AND if there is content for Christmas available.  2 is symbolic
in the database being Christmas.  Ron


IF( CURDATE( ) >= DATE_SUB( DATE(2009-12-25) , INTERVAL LEAST( 14, (
SELECT COUNT( * ) FROM `verse_of_the_day_Bible_verses` WHERE seasonal_use
=2 ) ) DAY ) AND CURDATE( ) <= DATE(2009-12-25) , 2, 0 )
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.