adwarm — 2011-09-05T12:18:12-04:00 — #1
UPDATE affpixels SET Pixel ='loudnewmedia.com' AND AffID ='3' AND ProID ='2' WHERE PixelID ='2'
Why wont the fields update? When i run the above Query it says 0 rows affected
So why wont it update? PixelID = 2 exists.
0 rows affected. ( Query took 0.0004 sec )
Any help would be great.
molona — 2011-09-06T02:29:47-04:00 — #2
Rudy is right. There should be commas there, and not ANDS. You would use ANDS with the conditions, the WHERE part, if you had more than one condition to met AND these additional conditions needed to be met in addition to the first.
r937 — 2011-09-05T14:58:02-04:00 — #3
interesting that it actually ran
the ANDs are wrong, they should be commas -- check da syntax in da manuals