[Pedido] Loop em MySQL como fazer

[Woorz]

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;
}

Opa irmão, valeu pela reposta. Então está dando estes erros abaixo.
Estou testando assim:

Código:

Dialog:FactionsList2(playerid, response, listitem, inputtext[])
{
if (response)
{
        ShowFactionMembersList(playerid, listitem);
    }
    return 1;
}


// ESSES ERROS AQUI NO ShowFactionMembersList //
/*
error 017: undefined symbol "cache_get_value_int"
error 017: undefined symbol "cache_get_value"
error 001: expected token: "-string end-", but found "-identifier-"
*/

Uso MYSQL R39-3
ShowFactionMembersList(playerid, factionid)
{
    new list[4096];

    mysql_tquery(g_iHandle, "SELECT `Faction`, `Character` FROM `characters`");

    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");
        }
    }
    Dialog_Show(playerid, FactionsList2, DIALOG_STYLE_TABLIST_HEADERS, "Membros", list, "Fechar", "");
}

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