country is not achieved into musql table
#1

PHP код:
 GetPlayerCountry(playeridstr2sizeof(str2));
     
mysql_format(g_SQLquerysizeof query"UPDATE `players` SET `country` = %s WHERE `id` = %d LIMIT 1",str2pInfo[playerid][ID]);
    
mysql_tquery(g_SQLquery); 
PHP код:
`countryvarchar(24NOT NULL 
Reply
#2

Код:
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?
Reply
#3

not working
Reply
#4

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.
Reply
#5

Love you, works like charm
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)