[iNoOx]

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)

[Shurik01]

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(playerid, strval(tmp));
mysql_free_result(); 


[iNoOx]

Thaaaaanks a lot !!!