[Dubya]

I have a question, if I am trying to obtain information from multiple rows in one query,

e.g:

Код:

SELECT `Username`,`ID` FROM `characters` WHERE `OwnerID`='1'

Can I get information on each of the rows that get a result? I really don't want to have to switch MySQL plugins, but I have never tried this before. If someone has found a way to do this, please share your tip with me?

- https://sampforum.blast.hk/showthread.php?tid=122983

Edit: Nevermind, answer not solved

[Dubya]

Edited again.. Answer not solved

[Dubya]

bump

[Misiur]

You already are fetching multiple rows. What's your current pawn code?

[SKAzini]

Are you looking for this?

pawn Код:

new string[500];
format(string, sizeof(string), "SELECT * FROM users WHERE Name = '%s'", UserStats[playerid][Name]);
mysql_query(string);
mysql_store_result();
                    
while (mysql_retrieve_row())
{
    mysql_fetch_field_row(string, "Password");
    format(UserStats[playerid][Password], 129, "%s", string);

    mysql_fetch_field_row(string, "Admin");
    UserStats[playerid][Admin] = strval(string);
                        
    mysql_fetch_field_row(string, "Kills");
    UserStats[playerid][Kills] = strval(string);
                        
    mysql_fetch_field_row(string, "Deaths");
    UserStats[playerid][Deaths] = strval(string);
}
mysql_free_result();

If this is what you're searching for, take a while to look through the code I gave you, eventually you will understand how it works.

[Dubya]

Quote:

Originally Posted by SKAzini Are you looking for this? pawn Код: new string[500]; format(string, sizeof(string), "SELECT * FROM users WHERE Name = '%s'", UserStats[playerid][Name]); mysql_query(string); mysql_store_result();                     while (mysql_retrieve_row()) {     mysql_fetch_field_row(string, "Password");     format(UserStats[playerid][Password], 129, "%s", string);     mysql_fetch_field_row(string, "Admin");     UserStats[playerid][Admin] = strval(string);                             mysql_fetch_field_row(string, "Kills");     UserStats[playerid][Kills] = strval(string);                             mysql_fetch_field_row(string, "Deaths");     UserStats[playerid][Deaths] = strval(string); } mysql_free_result(); If this is what you're searching for, take a while to look through the code I gave you, eventually you will understand how it works.

Thanks, I can work with BlueGz r6.