MySQL - Log error #1064
#2

You have an extra comma (,) right before "WHERE". Delete it and try again. This is how it should look:
pawn Код:
mysql_format(mysql, Query, sizeof(Query), "UPDATE accounts SET Skin='%d', Admin='%d', Score='%d', Kills='%d', Deaths='%d' WHERE ID='%d'",
        pInfo[playerid][Skin],pInfo[playerid][Admin],pInfo[playerid][Score],pInfo[playerid][Kills],pInfo[playerid][Deaths],pInfo[playerid][ID]);
Reply


Messages In This Thread
MySQL - Log error #1064 - by Saize - 09.02.2015, 21:00
Re: MySQL - Log error #1064 - by HazardouS - 09.02.2015, 21:05
AW: MySQL - Log error #1064 - by Saize - 09.02.2015, 21:14
Re: MySQL - Log error #1064 - by HazardouS - 09.02.2015, 21:17
Re: MySQL - Log error #1064 - by vassilis - 09.02.2015, 21:18
AW: Re: MySQL - Log error #1064 - by Saize - 09.02.2015, 21:21

Forum Jump:


Users browsing this thread: 1 Guest(s)