[gilmon]

It's work in mysql tools but seem don't work on my sourcemod plugin, thanks.

update pdate1 += 1, pdata2 += %i where steamid = "STEAM_1:1:1111111"

PHP Code:

decl String:query[105];
Format(query,sizeof(query), "update pdate1 += 1, pdata2 += %i where steamid = '%s'", ctmData, SteamID);
SendSQLUpdate(query); 


[Mehis]

You'll have to specify the table.

Something like this:

PHP Code:

UPDATE tablename SET pdata1 = pdata1 + 1, pdata2 = pdata2 + %i WHERE steamid = '%s' 


[gilmon]

Originally Posted by Mehis You'll have to specify the table. Something like this: PHP Code: UPDATE tablename SET pdata1 = pdata1 + 1, pdata2 = pdata2 + %i WHERE steamid = '%s'

Yeah i know that just paste something wrong here, the problem is not there.

[WildCard65]

Originally Posted by gilmon Yeah i know that just paste something wrong here, the problem is not there.

exact error from sql natives(or threaded callback error param)

[JoB2C]

The semicolon at the end of the command is maybe required.

[h3bus]

I think mySQL does not support the '+=' operator.
The request gilmon gave you is correct.

If not, having the reported mySQL error would help!