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@xxxxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Date: Thu, 13 Dec 2007 19:33:57 -0500 Subject: RE: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
