MySQL Error...
#1

Pawn Code:
pawn Код:
stock SavePlayerAccount(playerid)
{
    new queue[184];
    format(queue, sizeof(queue), "UPDATE `Players` SET AdminLevel= '%d', Score= '%d', Money= '%d', BankMoney= '%d', Kills= '%d', Deaths= '%d', Army= '%d', Swat= '%d', RobRank= '%d', TazerRank= '%d' WHERE Username= '%s'",
    PlayerData[playerid][AdminLevel], GetPlayerScore(playerid), GetPlayerMoney(playerid), PlayerData[playerid][BankMoney],
    PlayerData[playerid][Kills], PlayerData[playerid][Deaths], PlayerData[playerid][Army], PlayerData[playerid][Swat],
    PlayerData[playerid][RobRank], PlayerData[playerid][TazerRank], PlayerName(playerid));
    mysql_query(queue);
    return 1;
}
Error:
Код:
Error (0): Failed to exeute 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 ''Unkn' at line 1.
pawn Код:
use near ''Unkn' at line 1. //Look, It dont get my full name (Unknown123)
Reply


Messages In This Thread
MySQL Error... - by Unknown123 - 01.03.2011, 18:57
Re: MySQL Error... - by Bumbis - 01.03.2011, 19:01
Re: MySQL Error... - by Hiddos - 01.03.2011, 19:03
Re: MySQL Error... - by Unknown123 - 01.03.2011, 19:04

Forum Jump:


Users browsing this thread: 1 Guest(s)