MYSQL errors
#1

I have two mysql errors and I can't find the mistake in it.

Код:
Error (0): Failed to exeute query. Column count doesn't match value count at row 1.
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 ''15.48225' at line 1.
Saving
pawn Код:
stock SavePlayer(playerid)
{
    new query[126], pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, sizeof(pName));
    GetPlayerPos(playerid, PlayerS[playerid][Position][0], PlayerS[playerid][Position][1], PlayerS[playerid][Position][2]);
    format(query, sizeof(query), "UPDATE accounts SET Name = '%s', Password = '%s', PlayerX = '%f', PlayerY = '%f', PlayerZ = '%f' WHERE Name = '%s'", pName, PlayerS[playerid][Password], PlayerS[playerid][Position][0], PlayerS[playerid][Position][1], PlayerS[playerid][Position][2], pName);
    mysql_query(query);
}
Reply


Messages In This Thread
MYSQL errors - by MechaTech - 12.03.2013, 13:41
Re: MYSQL errors - by Misiur - 12.03.2013, 13:43
Re: MYSQL errors - by MechaTech - 12.03.2013, 16:13
Re: MYSQL errors - by Patrick - 12.03.2013, 16:46
Re: MYSQL errors - by MechaTech - 13.03.2013, 14:21
Re: MYSQL errors - by CoaPsyFactor - 13.03.2013, 14:30
Re: MYSQL errors - by Misiur - 13.03.2013, 14:56

Forum Jump:


Users browsing this thread: 1 Guest(s)