alex600
Умник
Помогите исправить [17:22:49] [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 `Name` = 'Test_Test'' at line 1
Вот код
и кому не трудно объясните как исправлять подобные проблемы
Вот код
PHP:
stock SavePlayer(i)
{
new scr[128];
new string[900];
format(string, sizeof(string),"UPDATE `accounts` SET");
format(scr, sizeof(scr), "`Skin` = %d,", Player[i][pSkin]);
strcat(string, scr);
format(scr, sizeof(scr), "`Money` = %d,", Player[i][pMoney]);
strcat(string, scr);
format(scr, sizeof(scr), "`Level` = %d,", Player[i][pLevel]);
strcat(string, scr);
format(scr, sizeof(scr), "`Password` = '%s',", Player[i][pPassword]);
strcat(string, scr);
format(scr, sizeof(scr), "WHERE `Name` = '%s'", Player[i][pName]);
strcat(string, scr, sizeof(string));
mysql_function_query(MysqlConnect, string, false, "", "");
}
