RE: [PHP-DB] UPDATE syntax
| From: | TG | Date: | Fri, 14 Dec 2007 01:08:57 +0000 |
| Subject: | RE: [PHP-DB] UPDATE syntax | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44410@lists.php.net to get a copy of this message | ||
Sorry, I didn't read the whole post, but wanted to point something out:
interestcodes.id is valid
interestcodes.id is valid
interestcodes.id is going to try to find a column named "itnerestcodes.id"
somewhere with no table association.
The backticks/single-quotes/whatever-you-wanna-call-them are used to be
explicit with a name.
-TG
----- Original Message -----
From: "Gary Wardell" <gwardell@gwsystems.co.il>
To: <php-db@lists.php.net>
Date: Thu, 13 Dec 2007 19:33:57 -0500
Subject: RE: [PHP-DB] UPDATE syntax
> 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