[severance]

PHP код:

 GetPlayerCountry(playerid, str2, sizeof(str2));
     mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `country` = %s WHERE `id` = %d LIMIT 1",str2, pInfo[playerid][ID]);
    mysql_tquery(g_SQL, query); 


PHP код:

`country` varchar(24) NOT NULL 


[XStormiest]

Код:

GetPlayerCountry(playerid, str2, sizeof(str2)); 
     mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `country` = '%s' WHERE `id` = '%d' LIMIT 1",str2, pInfo[playerid][ID]); 
    mysql_tquery(g_SQL, query);

try this?

[severance]

not working

[KinderClans]

pawn Код:

new Country[128];
GetPlayerCountry(playerid,Country);
mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `country` = '%s' WHERE `id` = '%d' LIMIT 1", Country, pInfo[playerid][ID]); 
mysql_tquery(g_SQL, query);

Also there is no need for LIMIT 1.

[severance]

Love you, works like charm