MySQL update error
#1

Hey guys!

I don't know what is wrong with this:

Код:
mysql_query("UPDATE Characters SET Level = 5, Respect = 0, NRespect = 4, Skin = 15, Cash = 400, Bank = 55000, Job = 1, Leader = 1, Group = 1, Rank = 1, House = 1, RHouse = 1, Car = 1, MBike = 1, Bike = 1 WHERE Username = 'John' AND Chara = 0");
It gives this error:

Код:
CMySQLHandler::Query(UPDATE Characters SET Level = 5, Respect = 0, NRespect = 4, Skin = 15, Cash = 400, Bank = 55000, Job = 1, Leader = 1, Group = 1, Rank = 1, House = 1, RHouse = 1, Car = 1, MBike = 1, Bike = 1 WHERE Username = 'John' AND Chara = 0) - An error has occured. (Error ID: 1064, 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 'Group = 1, Rank = 1, House = 1, RHouse = 1, Car = 1, MBike = 1, Bike = 1 WHERE U' at line 1)
Reply


Messages In This Thread
MySQL update error - by Steve M. - 07.04.2011, 14:33
Re: MySQL update error - by [UG]Scripter - 07.04.2011, 14:37
Re: MySQL update error - by Steve M. - 07.04.2011, 14:41
Re: MySQL update error - by [UG]Scripter - 07.04.2011, 14:43
Re: MySQL update error - by Sergei - 07.04.2011, 14:43
Re: MySQL update error - by Steve M. - 07.04.2011, 14:47
Re: MySQL update error - by Sascha - 07.04.2011, 14:52
Re: MySQL update error - by Steve M. - 07.04.2011, 14:56
Re: MySQL update error - by Sergei - 07.04.2011, 15:25
Re: MySQL update error - by Sascha - 07.04.2011, 15:26

Forum Jump:


Users browsing this thread: 1 Guest(s)