jeudi 8 mai 2014

problem saving variable

Hello,



There is my code who save the variable Note1:




Code:



format(string, sizeof(string), "UPDATE players SET Note1=%s WHERE id=%d",

PlayerInfo[playerid][pNote1],

PlayerInfo[pSQLID]);



But, I got this error:




Code:



CMySQLHandler::Query(UPDATE players SET Note1= WHERE id=) - An error has occured. (Error ID: 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 'Note2' at line 1)


This is the table:

When I do printf("Note1: %s",PlayerInfo[playerid][pNote1]");, He return None, what I want in my table...



Regards




Aucun commentaire:

Enregistrer un commentaire