SQL problem[ edited post ]
#3

Where you insert in the database? ) I don't see syntax "INSERT INTO" anywhere )

Change this codes:
Код:
format( r_Query, sizeof( r_Query ), "SELECT `DriftScore` FROM `Points` WHERE `Nume` = '%s'", GetName( playerid ) );
Rezultat = db_query( DriftPoints, r_Query );
//--------------------------------------------------------------------------------------
db_query( DriftPoints, "CREATE TABLE IF NOT EXISTS `Points` (`Nume`, `DriftScore`)" ); //Why you free the result if you don't have one?
//--------------------------------------------------------------------------------------
format( _Query, sizeof( _Query ), "UPDATE `Points` SET `DriftScore` = `%d` WHERE `Nume` = '%s'", value, GetName( playerid ) );
db_query( DriftPoints, _Query );
Now it shout work ...
Reply


Messages In This Thread
solved! - by Rock1 - 25.03.2012, 11:12
Re: SQL problem[ edited post ] - by fordawinzz - 25.03.2012, 11:21
Re: SQL problem[ edited post ] - by Edvin - 25.03.2012, 12:26
Re: SQL problem[ edited post ] - by Rock1 - 25.03.2012, 17:56
Re: SQL problem[ edited post ] - by Edvin - 25.03.2012, 18:33
Re: SQL problem[ edited post ] - by Rock1 - 25.03.2012, 21:01

Forum Jump:


Users browsing this thread: 2 Guest(s)