Mysql query
| From: | ron dot piggott at actsministries dot org | Date: | Sun, 13 Dec 2009 23:00:53 +0000 |
| Subject: | Mysql query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46684@lists.php.net to get a copy of this message | ||
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 )