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 */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
