Mysql query
| 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 )