[FireCat]

Quero selecionar da minha table o AccID
Estб em auto_increment mas nгo sei como lб chegar
Codigo:

pawn Код:

if(dialogid == Regdialog2)//Inputting password dialog
    {
        new string[200],tempquery[100],PlayerAccID;
        if(strlen(inputtext) == 0)
        {
            ShowPlayerDialog(playerid,Regdialog2,DIALOG_STYLE_INPUT,""cblue"Register - "cyellow"Enter your password",""cblue"You are about to register a "cyellow"new account"cblue"! \nPlease choose the "corange"password"cblue" for it! \n","Register!","");
            SendClientMessage(playerid,red,"Please input a password!");
        }
        else
        {
            format(Query,sizeof(Query),"INSERT INTO `Users` (Username,Password) VALUES ('%s','%s')",GetPName(playerid),inputtext);
            mysql_query(Query);
            format(tempquery,sizeof(tempquery),"SELECT * FROM `Users` WHERE `Username` = '%s' AND `AccID` = '%i'",GetPName(playerid),PlayerAccID);
            mysql_query(tempquery);
            mysql_store_result();
            SendClientMessage(playerid,green2,"You have been successfully registered!");
            format(string,sizeof(string),""cgreen"You have been successfully registered! \n"cwhite"» Your username: "cblue"%s \n"cwhite"» Your password: "cblue"%s \n"cwhite"» Your account ID: "cblue"%i",GetPName(playerid),inputtext,PlayerAccID);
            ShowPlayerDialog(playerid,Reginfo,0,"Registered!",string,"Ok","");
            mysql_free_result();
        }
    }

[Bryaan_Smith]

format(tempquery,sizeof(tempquery),"SELECT * FROM `Users` WHERE `Username` = '%s' AND `AccID` = '%i'",GetPName(playerid),PlayerAccID);

Й sу editar, "SELECT" = seleciona, USERS = Tabela dentro da DB, e WHERE = COLUNA de dentro da tabela.. SQL й Facil

Ajudei? Reputaзгo *-*

[[S]trong]

Se estб querendo selecionar a AccID para salvar em um arquivo й isto o Query.

pawn Код:

format(tempquery,sizeof(tempquery),"SELECT `AccID` FROM `Users` WHERE `Username` = '%s'",GetPName(playerid));

[FireCat]

Jб tinha arranjado :b Mas obrigado na mesma