Get name mysql
#1

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;
}
Reply
#2

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;
}
Reply
#3

pawn Код:
(2524) : error 035: argument type mismatch (argument 1)
in line:

pawn Код:
mysql_fetch_field_row(IDD, "mid");
Reply
#4

pawn Код:
//change
mysql_fetch_field_row(IDD, "mid");

//to
mysql_fetch_field_row(string, "mid");
IDD = strval(string);
Wrong habit activated
Reply
#5

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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)