Re: [fw-general] Using fetch() in a loop, internal query doesn't work

2009-05-23 Thread Thesee
If you read my first post you can see that I used al type of Zend_Db methods, first of all the Zend_Db_Statement Thank you Kamil N wrote: Hi You can use Zend_Db_Statement http://framework.zend.com/manual/en/zend.db.statement.html Example $stmt = $db-query('SELECT * FROM

RE: [fw-general] Using fetch() in a loop, internal query doesn't work

2009-05-22 Thread Thesee
Thanks for answer, what i wrote is only an example, no parse error on the code i'm testing or query error ;) I tried all, many times, many days ago (and now to be sure..) all without success. $db-query $db-update or table model, neither works, the loop exit after first cycle with no errors,

RE: [fw-general] Using fetch() in a loop, internal query doesn't work

2009-05-22 Thread Thesee
Yes, all tested. no way. to reproduce it: database: DROP TABLE IF EXISTS `bugs`; CREATE TABLE IF NOT EXISTS `bugs` ( `bugid` int(11) NOT NULL auto_increment, `desc` varchar(255) NOT NULL, `solved` tinyint(4) NOT NULL, PRIMARY KEY (`bugid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

[fw-general] Using fetch() in a loop, internal query doesn't work

2009-05-21 Thread Thesee
Hi all, i'm having some trouble fetching and making query trough a loop. (sorry for my bad english) to explain , please read the example : suppose to have 100 bugs unsolved. $stmt = $db-query('SELECT * FROM bugs'); while ($row = $stmt-fetch()) { echo $row['bug_description'].'br/'; } we

[fw-general] Zend_Db_Table_Abstract problem fetching db result on nested routine

2009-04-23 Thread Thesee
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