[ancezas]

i what to fetch player name but i fail code:

pawn Код:

CMD:testukas(playerid, params[])
{
    mysql_query( "SELECT MAX(ID) FROM `vartotojai`" );
    mysql_store_result();
    if (mysql_num_rows())
    {
        new IDD = mysql_fetch_int(),
            string[ 128 ];
        mysql_query( "SELECT `Vardas` FROM `vartotojai` WHERE `ID` = '%i'", IDD);
        mysql_store_result();
        new fetch[ 24 ];
        new Vardukas[ 24 ] = mysql_fetch_field_row(fetch, "Vardas");

        format(string, sizeof(string), "Max ID: %i %s", IDD, Vardukas);
        SendClientMessage(playerid,-1,string);
        mysql_free_result();
    }
    mysql_free_result();
    return 1;
}