04.05.2013, 20:10
Delete , before WHERE and when you are saving numbers ' ' are useless and every column has to be betwen ` `
Correct code:
I also added Limit to prevent affecting multiple rows
Correct code:
pawn Код:
format(query, sizeof(query), "UPDATE `players` SET `jskill` = %d,`mskill` = %d,`dskill` = %d ,`fskill` = %d WHERE `id` = %d LIMIT 1",PlayerInfo[playerid][jskill],PlayerInfo[playerid][mskill],PlayerInfo[playerid][dskill],PlayerInfo[playerid][fskill],PlayerInfo[playerid][SQLID]);