RE: [PEAR] Trying to loop through MDB rowset -

Hi, > -----Original Message----- > From: Matt Friedman [mailto:matt@sprynewmedia.com] > Sent: Thursday, November 07, 2002 5:50 PM > > I had thought that this would work ok: > -------------------------------------------------- > $sql = " SOME SQL HERE "; > $rs = $this->db->query($sql); > while( $row = $this->db->fetchRow($rs, MDB_FETCHMODE_ASSOC) ) { > // do something with the row info... > } > -------------------------------------------------- > hmm i think i will put that one in a faq when i start on the peardoc2 documentation :-) all of the fetch[One|Row|Col|All](), query[One|Row|Col|All](), get[One|Row|Col|All|Assoc]() free the result set immediately. Therefore after the first call to fetchRow $rs will be freed. What you rather want to do is this: $sql = " SOME SQL HERE "; $rs = $this->db->queryAll($sql); foreach( $rs as $row ) { // do something with the row info... } maybe some error checking as well .. regards, Lukas Smith smith@dybnet.de _______________________________ DybNet Internet Solutions GbR Reuchlinstr. 10-11 Gebäude 4 1.OG Raum 6 (4.1.6) 10553 Berlin Germany Tel. : +49 30 83 22 50 00 Fax : +49 30 83 22 50 07 www.dybnet.de info@dybnet.de