RE: [PHP-DB] UPDATE syntax
| From: | Gary Wardell | Date: | Fri, 14 Dec 2007 00:33:57 +0000 |
| Subject: | RE: [PHP-DB] UPDATE syntax | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44409@lists.php.net to get a copy of this message | ||
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 |Å®J´4>%_7Ñ/
> ¯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
>
>