My MYSQL query don't work. - Printable Version

My MYSQL query don't work. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: My MYSQL query don't work. (/showthread.php?tid=546568)

My MYSQL query don't work. - xHanks - 16.11.2014

I made this code when one user disconnect, the problem is about don't update this in my db.

pawn Код:

new solicitud[359], Float:PosicX, Float:PosicY, Float:PosicZ,name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, sizeof(name));
GetPlayerPos(playerid, PosicX, PosicY, PosicZ);
format(solicitud, sizeof(solicitud), "UPDATE `usuarios` SET `Nivel`=%d, `Dinero`=%d,`PosX`=%f,`PosY`=%f,`PosZ`=%f WHERE `Usuario`=%s",\
pInfo[playerid][pNivel],pInfo[playerid][pDinero],PosicX,PosicY,PosicZ, name);
mysql_query(mysql, solicitud);

Re: My MYSQL query don't work. - Lordzy - 16.11.2014

Strings have to be between single quotes while executing a query. '%s'

pawn Код:

`Usuario`='%s'