[Saize]

Hey guys,

Iґm still testing a bit around with MySQL (BlueGґs Plugin), and the accounts just dont save

So I checked the MySQL Log and I got the following error

Quote:

[06:03:45] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'WHERE ID=''' at line 1

And here is the Code

PHP код:

public OnPlayerDisconnect(playerid, reason)
{
    if(LoggedIn[playerid] == 1)
    {
        new Query[256];
        
        mysql_format(mysql, Query, sizeof(Query), "UPDATE accounts SET Skin='%d', Admin='%d', Score='%d', Kills='%d', Deaths='%d', WHERE ID='%d'",
        pInfo[playerid][Skin],pInfo[playerid][Admin],pInfo[playerid][Score],pInfo[playerid][Kills],pInfo[playerid][Deaths],pInfo[playerid][ID]);
        mysql_tquery(mysql, Query, "", "");
        LoggedIn[playerid] = 0;
        return 1;
       }
    return 1;
} 


It didnt shown any error or warning while compiling, but I couldnt figure out what Iґve done wrong