Stupid simple query stressing me out a LOT

[AliasZero]

I have this query for mySQL:

UPDATE 'members' WHERE 'UserName'='Admin' SET 'UserName'='Admin', 'UserEmail'='[e-mail]2', 'UserRealname'='The Administrator2', 'UserAddress'='12 tree lane countryland some county2', 'UserCountry'='united kingdom', 'UserPhone'='0800 215000'

but i'm getting syntax error when i try and execute it on my database.

i've wasted around 2 hours of my free time(i dont have a lot) trying to fix this and i can't, nomatter what i do.

oh, and this is the 2nd time i've typed this - safari decided to redirect me to amazon as i was about to submit :mad

could ANYONE help?????

[leatherback]

Hi,

remove the single quotes around colum names, and I think it should work just fine:

UPDATE members WHERE UserName='Admin' SET UserName='Admin', UserEmail='[e-mail]2', UserRealname='The Administrator2', UserAddress='12 tree lane countryland some county2', UserCountry='united kingdom', UserPhone='0800 215000' 

<edited>:
It may also throuw erros due to capital letters... The server may refuse to use them sometimes. Better avoid them in naming tables/colums..

[AliasZero]

nop,

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE UserName = 'Admin' SET UserName = 'Admin',
UserEmail =

[kristianblom]

Why do you update the UserName when UserName is the condition used to identify entry to update? This might cause trouble... But I dont know for sure

[Doug_G]

The WHERE clause goes after the SET part.

UPDATE ... SET ... WHERE ...