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

Reply via email to