MySQL, problem
#1

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
Reply


Messages In This Thread
MySQL, problem - by bfkj - 19.04.2010, 22:12
Re: MySQL, problem - by Carlton - 19.04.2010, 22:46
Re: MySQL, problem - by bfkj - 19.04.2010, 23:01

Forum Jump:


Users browsing this thread: 1 Guest(s)