[StreetRP]

Hello ..
I get a bug ..This code don't get the name .
.

PHP код:

NameMysql(playerid)
{
    
    new nameR[MAX_PLAYER_NAME+1];
    static query[60], DBResult:db_result;
    
    format(query, sizeof query, "SELECT `name` FROM `users` WHERE `id` = '%d'", playerid);
    
    db_result = db_query(mysql, query);
    if(db_num_rows(db_result))
    {
    cache_get_field_content(db_result, "name", nameR, mysql, sizeof nameR);
    }
    db_free_result(db_result);
    
    return nameR;
} 


Are is a error ?

Thanks for you'r help !

[StreetRP]

Resolved !

PHP код:

NameMysql(playerid)
{
    new nameR[MAX_PLAYER_NAME+1];
    static query[60], Cache:result;
    format(query, sizeof query, "SELECT `name` FROM `users` WHERE `id` = '%d'", playerid);
    result = mysql_query(mysql, query);
    cache_get_field_content(0, "name", nameR, mysql, sizeof nameR);
    cache_delete(result);
    return nameR;
}