[bfkj]

Hey guys,

i have a problem with MySQL. I want to save the Money in a field, but i got a error message:

Here is it:

Код:

[21:34:44] [join] Lord has joined the server (0:127.0.0.1)[21:35:00] MySQL Error (0): Could not execute query. 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 '' at line 1.[21:35:00] UPDATE `userdata` set `money` =[21:35:00][21:35:00] [part] Lord has left the server (0:1)

Here are the lines where i want to save the money:

Код:

      new query[32];
      new Cash = GetPlayerMoney(playerid);
			format(query,sizeof(query),"UPDATE `userdata` SET `money` = '%s' WHERE `Nickname` = '%s'",Cash,playername);
			mysql_query(query);

I use this Plugin for MySQL: http://forum.sa-mp.com/index.php?topic=148182.0

[Carlton]

Watch your formats, be careful. Use this query. Your problem was you tried to update a int with a string format.

pawn Код:

UPDATE `userdata` SET `money` = %d WHERE `Nickname` = '%s'

[bfkj]

Ok i was changed, but i was become the same error message,. =/


Edit: Thanks champ it run =).