[Pedido] Loop em MySQL como fazer

[Vel]

Código:

ShowFactionMembersList(playerid, factionid) {
  new list[4096];

  mysql_query(MYSQL_DEFAULT_HANDLE, "SELECT `fid`, `nome` FROM `contas`");

  for (new i; i < cache_num_rows(); i++) {
    new fid = -1;

    if ((cache_get_value_int(i, 0, fid), fid) == factionid) {
      new name[MAX_PLAYER_NAME + 1];

      cache_get_value(i, 1, name);

      format(list, sizeof(list), "%s%s\t%s\n", list, name, GetPlayerIDByName(name) == INVALID_PLAYER_ID ? "Offline" : "Online");
    }
  }

  ShowPlayerDialog(playerid, 0, DIALOG_STYLE_TABLIST, "Membros", list, "OK", "");
}

GetPlayerIDByName(const name[]) {
  new playerid = INVALID_PLAYER_ID;
  return sscanf(name, "r", playerid), playerid;
}