[StreetRP]

Hello i had do this but he doesent work ..

PHP код:

stock GetNameFID(NomFID)
{
    new idName[26];
    F(query, sizeof(query), "SELECT name FROM accountsWHERE id='%d'", playerInfo[NomFID][id]);
    mysql_query(query);
    mysql_store_result();
    if(!mysql_num_rows())
    {
        print("Unable to load");
        mysql_free_result();
        return 0;
    }
    while(mysql_fetch_row(query))
    {
        mysql_get_field("name", idName); F(playerInfo[NomFID][name], 32, "%s", idName);
    }
    mysql_free_result();
    return 1;
} 


I wan to get a name frome a id in my MYSQL table

[bgedition]

Quote:

Originally Posted by StreetRP pawn Код: F(query, sizeof(query), "SELECT name FROM accountsWHERE id='%d'", playerInfo[NomFID][id]);

should be:

pawn Код:

F(query, sizeof(query), "SELECT `name` FROM `accounts` WHERE `id` = '%d'", playerInfo[NomFID][id]);

[StreetRP]

Thks but doesen't workd :/

[StreetRP]

Anyone ?

[biker122]

Can you show us where you use this stock? (If it's a command, show it fully. Same goes if it's a function)

[Ironboy]

Give it a whack

pawn Код:

stock GetNameFID(NomFID)
{
    new idName[26];
    F(query, sizeof(query), "SELECT `name` FROM `accounts` WHERE `id` = '%d'", playerInfo[NomFID][id]);
    mysql_query(query);
    mysql_store_result();
    if(!mysql_num_rows())
    {
        print("Unable to load");
        mysql_free_result();
        return 0;
    }
    else if(mysql_num_rows() != 0)
    {
        while(mysql_fetch_row_format(query, "|"))
        {
            mysql_fetch_field_row(idName, "name"); F(playerInfo[NomFID][name], 32, "%s", idName);
        }
    }
    mysql_free_result();
    return 1;
}

[ea8de1]

pawn Код:

stock GetNameFID(NomFID) 
{ 
    new idName[26]; 
    F(query, sizeof(query), "SELECT name FROM accounts WHERE id='%d'", playerInfo[NomFID][id]); 
    mysql_function_query(1,query,true,"OnGetNameFID", "i",NomFID);
    return 1;
}

forward OnGetNameFID(NomFID);
public OnGetNameFID(NomFID)
{
    mysql_store_result(); 
    if(!mysql_num_rows()) 
    { 
        print("Unable to load"); 
        mysql_free_result(); 
        return 0; 
    } 
    while(mysql_fetch_row(query)) 
    { 
        mysql_get_field("name", idName); F(playerInfo[NomFID][name], 32, "%s", idName); 
    } 
    mysql_free_result(); 
    return 1; 
}

Untested.