MySQL ERROR
#1

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 .
Reply


Messages In This Thread
MySQL ERROR - by SanCio - 21.11.2012, 15:24
Re: MySQL ERROR - by CmZxC - 21.11.2012, 15:28
Re: MySQL ERROR - by SanCio - 21.11.2012, 15:34
Re: MySQL ERROR - by SanCio - 21.11.2012, 16:01
Re: MySQL ERROR - by SanCio - 22.11.2012, 13:17
AW: MySQL ERROR - by Skimmer - 22.11.2012, 14:03
Re: MySQL ERROR - by SanCio - 22.11.2012, 16:45

Forum Jump:


Users browsing this thread: 1 Guest(s)