Prev: Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?
Next: Mysql query
From: ron.piggott on 13 Dec 2009 18:00
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 )

 | 
Pages: 1
Prev: Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?
Next: Mysql query