[SanCio]

Hi , i have problem with mySQL save.

CODE :

Код:

 format ( query , sizeof ( query ) , "UPDATE `login` SET `IP`='%s' WHERE ( `Vardas`='%s' )" , GetPlayerIpEx ( playerid ) , GetPlayerNameEx ( playerid ) )  ;
	 mysql_query ( query ) ;
	 format ( query , sizeof ( query ) , "UPDATE `login` SET `Valanda`='%i' , `Minute`='%i' , `Secunde`='%i' , `Metas`='%i` , `Menesis`='%i' , `Diena`='%i'  WHERE ( `Vardas`='%s' )" , val , mins , sec , year , month , day , GetPlayerNameEx ( playerid ) ) ;
	 mysql_query ( query )  ;

ERROR :

Код:

[Wed Nov 21 18:31:50 2012] Function: mysql_query executed: "UPDATE `login` SET `Valanda`='18' , `Minute`='31' , `Secunde`='50' , `Metas`='2012` , `Menesis`='11' , `Diena`='21'  WHERE ( `Vardas`='Sasha_Hriundel' )" with result: "1".
[Wed Nov 21 18:31:50 2012] 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 '11' , `Diena`='21'  WHERE ( `Vardas`='Sasha_Hriundel' )' at line 1.

Thanks for help .

[CmZxC]

try removing ' when its %i, i dont think they need those.

[SanCio]

Don't work

[SanCio]

HELP ! Please .

[SanCio]

UP! Please help!

[Skimmer]

Is login your table name? If not change it please.
Try this.

pawn Код:

format(query, sizeof(query), "UPDATE login SET IP = '%s' WHERE Vardas = '%s'" , GetPlayerIpEx ( playerid ) , GetPlayerNameEx ( playerid ) )  ;
mysql_query(query);
format(query, sizeof(query) , "UPDATE login SET Valanda = '%d', Minute = '%d', Secunde = '%d', Metas = '%d , Menesis = '%d', Diena = '%d' WHERE Vardas = '%s'" , val , mins , sec , year , month , day , GetPlayerNameEx ( playerid ) ) ;
mysql_query(query);

[SanCio]

THANKS WORK!