UPDATE syntax
| From: | Ron Piggott | Date: | Fri, 14 Dec 2007 00:20:15 +0000 |
| Subject: | UPDATE syntax | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44408@lists.php.net to get a copy of this message | ||
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