Ron Piggott wrote:
This is the actual code.  What should I have?


Same as when you do a query normally.

$query = "SELECT ... WHERE ....";

$result = mysql_query($query);

.....

On Thu, 2009-09-24 at 13:20 +1000, Chris wrote:
Ron Piggott wrote:
The following code gives me this error message:

Parse error: syntax error, unexpected ':'
in /home/thev4173/public_html/test.php on line 8

It is referencing the : that follows EasterDate (and will eventually get
mad at ChristmasDate)


mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

IF(CURDATE() >= DATE_SUB(CONCAT(@EasterDate :=
DATE(FROM_UNIXTIME(easter_date(date('Y'))), INTERVAL LEAST(14, (SELECT
COUNT(*) FROM `verse_of_the_day_Bible_verses` WHERE seasonal_use = 1))
DAYS) AND CURDATE() <= @EasterDate, 1, 0)

IF(CURDATE() >= DATE_SUB(CONCAT(@ChristmasDate := YEAR(CURDATE()),
'-12-25'), INTERVAL LEAST(14, (SELECT COUNT(*) FROM
`verse_of_the_day_Bible_verses` WHERE seasonal_use = 2)) DAYS) AND
CURDATE() <= @ChristmasDate, 2, 0)

mysql_close();



What is the problem?
If this is your actual code, the queries aren't in php variables.

$query = "IF(curdate() .... ";





--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to