[BlackWolf120]

hi,

i want to list all players with a certain field value but it only picks the first player that has a specific value and then it stops selecting

pawn Код:

if (strcmp("/blackbans", cmdtext, true) == 0)
{
    if(Spieler[playerid][AdminLevel] > 2)
    {

    new query[320];
    format(query, sizeof(query), "SELECT name FROM `Users` WHERE Score > 0");//i want players with this value
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_row(query);
    print(query);//but only 1 player with the value i want is returned

    mysql_free_result();

    }else return SendClientMessage(playerid, 0xFF0000FF, "You don't have permission to use this command!");
    return 1;
}

So how would i make it like it does not stop after the first player but go on untill all players with that value are listed?

thx in advance