Hi all,
i'm having a problem while fetching a result set on a nested routine.
I think it's more simple to read the example:
$myFirstTable = new myFirstTable();// extetend Zend_Db_Table_Abstract
$mySecondTable = new mySecondTable();// extetend Zend_Db_Table_Abstract
the i call a function that get some rows from db (i don want to use fetchAll
due to big set of results, so i use query statment)
$result = $myFirstTable->getResult($id);
while ($row = $result->fetch()) {
//do some logic
//but if I use another query to db the while loop will stop immediatly
$mySecondTable->updateMyrecord($mycalcualtedId);
//if I not use this call o any call to db the loop finish correctly
}
So to solve this problem i' going to waste memory fetching all result on an
array and then
looping and this work.
foreqach ($myresults as $foo => $bar) {
//do somet logic
$mySecondTable->updateMyrecord($mycalcualtedId);
}
Someone can drive me on right direction?
Thank you
--
View this message in context:
http://www.nabble.com/Zend_Db_Table_Abstract-problem-fetching-db-result-on-nested-routine-tp23193450p23193450.html
Sent from the Zend Framework mailing list archive at Nabble.com.
