Re: DB will INSERT wont UPDATE..error in code?

Please do not top-post. On Wednesday 13 October 2004 10:26, Matthew Kiehne wrote: > sorry this is the output i meant to post > SQL statement = UPDATE badges SET staff = '1' ttlpst = '1' mnthpst = > '1' > ttlicon = '/trophies' mnthicon = '/ribbons' WHERE fid = 61 > > and this is the error i get....yet i still cant for the life of me find a > problem > > Update query = UPDATE badges SET staff = '1' ttlpst ='1' mnthpst = > '1' > ttlicon = 'trophies' mnthicon = 'medals' WHERE fid = 61Query3 failed: You > have an error in your SQL syntax near 'ttlpst ='1' mnthpst = '1' > ttlicon = > 'trophie' at line 3 If you look up the manual entry for UPDATE, you'll find that you're missing the commas separating the columns. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* I'm free -- and freedom tastes of reality. -- The Who */