PHP DB - UPDATE syntax

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

UPDATE syntax

Ron Piggott

2007-12-13, 10:00 pm

Can anyone see something wrong with this syntax?

UPDATE `advertisements` INNER JOIN `advertisements_rate_plans` ON
`advertisements.rate_plan` = `advertisements_rate_plans.reference` SET
`advertisements.displayed` = 0 WHERE `advertisements.start_date` <=
'2007-12-13' AND `advertisements.end_date` >= '2007-12-13' AND
`advertisements.approved` =1 AND `advertisements.paid` =1 AND
`advertisements.displayed` =1 AND `advertisements_rate_plans.type` =2

I am getting this error message:

#1054 - Unknown column 'advertisements.displayed' in 'field list'

There is a column called "displayed" in table "advertisements".

I am on the http://dev.mysql.com/doc/refman/5.0/en/update.html page and
I am missing something.

Ron

Sponsored Links