09.12.2016, 06:30
If you're updating values that are already in the database, you just use..
Just an example
If you don't want to use mysql_format use %q for strings to escape them.
Though many would recommend saving with their database ID, instead of their usernames
Just an example
PHP код:
new query2[200];
mysql_format(mysql, query2 , sizeof(query2), "UPDATE `users` SET PS = 'abc', SC = '%d,' MN = '%d', DT = '%d' WHERE PN = '%e'", GetPlayerScore(playerid), GetPlayerMoney(playerid), deaths[playerid], playername);
mysql_query(mysql, query2);
Though many would recommend saving with their database ID, instead of their usernames