[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;
}

[Misiur]

Read about threaded queries.

pawn Код:

CMD:testukas(playerid, params[])
{
    mysql_query( "SELECT MAX(ID) as mid, `Vardas` FROM `vartotojai` ORDER BY ID DESC LIMIT 0,1" );
    mysql_store_result();
    if (mysql_num_rows())
    {
        new Vardukas[ 24 ], IDD, string[64];
        mysql_fetch_field_row(Vardukas, "Vardas");
        mysql_fetch_field_row(IDD, "mid");
        format(string, sizeof(string), "Max ID: %i %s", IDD, Vardukas);
        SendClientMessage(playerid,-1,string);
    }
    mysql_free_result();
    return 1;
}

[ancezas]

pawn Код:

(2524) : error 035: argument type mismatch (argument 1)

in line:

pawn Код:

mysql_fetch_field_row(IDD, "mid");

[Misiur]

pawn Код:

//change
mysql_fetch_field_row(IDD, "mid");

//to
mysql_fetch_field_row(string, "mid");
IDD = strval(string);

Wrong habit activated

[ancezas]

not working at all your script, in my script i get max ID whit your code i still didint get name and not geting ID