[Ajuda] SQL syntax
#1

Erro
pawn Code:
[20:51:29] [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 Usuario='ivis' at line 1
Code:
stock SalvarDados(playerid)
{
    new myQuery[100];
	format(myQuery, 100, "UPDATE `contas` SET `Matou`='%d', `Morreu`='%d', `Dinheiro`='%d', `Skin`='%d', WHERE Usuario='%s'", Player[playerid][pMatou], Player[playerid][pMorreu], GetPlayerMoney(playerid), GetPlayerSkin(playerid) ,GetNome(playerid));
	mysql_tquery(mysql, myQuery, "","");
	print("dados salvos");
	return 1;
}
eu tava usando o nick ivison_r
Reply


Messages In This Thread
SQL syntax - by _Play_ - 13.07.2015, 23:53
Re: SQL syntax - by FallweN - 13.07.2015, 23:59
Re: SQL syntax - by _Play_ - 14.07.2015, 00:04
Re: SQL syntax - by PT - 14.07.2015, 00:10
Re: SQL syntax - by _Play_ - 14.07.2015, 00:13
Re: SQL syntax - by Ricop522 - 14.07.2015, 14:13
Re: SQL syntax - by n0minal - 14.07.2015, 17:33

Forum Jump:


Users browsing this thread: 3 Guest(s)