MYSQL Problem
#1

If I use /setlevel my Level change in Game but not in my database is there a mistake in this line ?

PHP код:
format(query,sizeof(query),"UPDATE user SET Score='%i',money='%i',AdminLevel='%i', WHERE ID='%i'",sInfo[playerid][Score],GetPlayerMoney(playerid),sInfo[playerid][AdminLevel],sInfo[playerid][ID]); 
MYSQL_LOG.TXT
PHP код:
[16:13:40] [ERRORCMySQLQuery::Execute[()] - (error #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 'WHERE ID='1'' at line 1 
Reply


Messages In This Thread
MYSQL Problem - by AwokenNeoX - 15.09.2014, 14:20
Re: MYSQL Problem - by Eth - 15.09.2014, 14:23
AW: MYSQL Problem - by AwokenNeoX - 15.09.2014, 14:26
Re: MYSQL Problem - by Eth - 15.09.2014, 14:27
AW: MYSQL Problem - by AwokenNeoX - 15.09.2014, 14:31
Re: MYSQL Problem - by MikeEd - 15.09.2014, 14:34
Re: MYSQL Problem - by Eth - 15.09.2014, 16:54
Re: MYSQL Problem - by Ox1gEN - 15.09.2014, 20:52
Re: MYSQL Problem - by DobbysGamertag - 15.09.2014, 21:23
Re: MYSQL Problem - by rickisme - 15.09.2014, 21:56

Forum Jump:


Users browsing this thread: 1 Guest(s)