Re: Parse error

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/