MySQL question
#1

Hi all,

So, i have a little problem ... i don't know how to get a value in a row for command...


Ex:

pawn Код:
new query[100],PName[MAX_PLAYER_NAME],Skin;
GetPlayerName(playerid,PName,sizeof(PName));
format(query,sizeof(query),"SELECT Skin FROM comptes WHERE Nom = '%s'",PName);
mysql_query(query);
mysql_store_result();
................ // Needed to remplace for get skin value
SetPlayerSkin(playerid,Skin);  // Value Skin get in query
mysql_free_result();

What can i write instead of the points.. ?

Thx lot for help

PS: I Use StrickenKid MySQL plugin

(Sorry for my bad english, i'm french :P)
Reply
#2

PHP код:
new query[100],PName[MAX_PLAYER_NAME],tmp[16];
GetPlayerName(playerid,PName,sizeof(PName));
format(query,sizeof(query),"SELECT Skin FROM comptes WHERE Nom = '%s'",PName);
mysql_query(query);
mysql_store_result();
// Needed to remplace for get skin value
mysql_fetch_field("Skin"tmp);
SetPlayerSkin(playeridstrval(tmp));
mysql_free_result(); 
Reply
#3

Thaaaaanks a lot !!!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)