Res: [fw-db] Parsing through large result sets

Hi,

You can do this:

$sql = "SELECT something FROM random-table-with-an-obscene-large-amount-of-entries";
$res = $db->query($sql);
while ($row = $res->fetch(Zend_Db::FETCH_NUM)) {
  // do some with the data returned in $row
}

Regards,
Luiz Fernando

---

De: janpolsen <janpolsen@gmail.com>
Para: fw-db@lists.zend.com
Enviadas: Sexta-feira, 31 de Outubro de 2008 8:48:49
Assunto: [fw-db] Parsing through large result sets

Oi

Now I have googled through various search queries for the last two hours and I'm about to toss the towel.

I am used to do something like this:

$sql = "SELECT something FROM random-table-with-an-obscene-large-amount-of-entries";
$res = mssql_query($sql);
while ($row = mssql_fetch_array($res)) {
  // do some with the data returned in $row
}

Now I have moved over to Zend_Db and want to do the very same thing, but how?
Some places I use a simple straight through approach like:

$sql = "SELECT something FROM random-table-with-a-small-amount-of-data";
$rows = $db->fetchAll($sql);
foreach ($rows AS $row) {
  // do some with the data returned in $row
}

However I run into memory problems, if I use that approach with my random-table-with-an-obscene-large-amount-of-entries.

What am I missing here? Isn't it possible to use a while()-structure to loop through a Zend_Db result set? Thanks in advance...

---

View this message in context: Parsing through large result sets
Sent from the Zend DB mailing list archive at Nabble.com.

---

Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.