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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
