[Haydz]

something like this should work.

pawn Код:

new rQuery[60],rName[MAX_PLAYER_NAME];
format(rQuery, sizeof(rQuery), "SELECT `username` FROM `users` WHERE `special = 1");
mysql_query(rQuery);
mysql_store_result( );
while(mysql_fetch_row(rQuery))
{
    sscanf(rQuery, "s[24]", rName);
    //then youc an use rName to display the players names.
}

when you use 'while' it will do the code you put as it finds the matches on the db.