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-th
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
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` >
Dear Friends
This message was sent to me by a friend and hope that you are aware about
this.
It has been brought to my attention that there will be an awful film
appearing soon in America which depicts our Beloved PROPHET
(Peace be upon him) as a homosexual (NAAOUZOBILLAH?)
When we thought these p
