| Gary Wardell 2007-12-13, 10:00 pm |
| Hi,
I'm a beginner at PHP and MySql but a long time MS SQL server user.
Maybe it should be `advertisements`.`displayed` instead?
I just did a test and my Query browser doesn't like `interestcodes.id` but likes `interestcodes`.`id`. Notice the quotes
(accents) on each side to the period.
Gary
> -----Original Message-----
> From: Ron Piggott [mailto:ron.php@actsministries.org]
> Sent: Thu, December 13, 2007 7:20 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] UPDATE syntax
>
>
> 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
>
>
|