Mysql problem
#2

That's nt how UPDATE queries work.

pawn Код:
mysql_format(handle, sqlSaveString, 2048, "UPDATE table_name SET `Inviter` = '%s', `Name` = '%s', Password = '%s', Sex = %d, Skin = %d", PI[playerid][pInviter], GetName(playerid), PI[playerid][pPassword], PI[playerid][pSex], PI[playerid][pSkin]);  
    mysql_tquery(handle, sqlSaveString, "", "");
Change the 'table_name' to your table name. Also as there is no WHERE clause it will set these values for ALL rows and I'm quite sure that's not what you want.
Reply


Messages In This Thread
Mysql problem - by Welaurs - 06.06.2016, 07:12
Re: Mysql problem - by dusk - 06.06.2016, 07:26

Forum Jump:


Users browsing this thread: 1 Guest(s)