Re: [PHP] Looping through a Db query result twice in PEAR

On Wed, May 24, 2006 at 02:28:33PM -0600, Phillip S. Baker wrote: > Greetings All, > > I have a problem that I usually solve in MySQL pretty easily, but using > PEAR identifiers are not working. > Any suggestions. > I want to loop through a result set in two different while loops that > are not

RE: [PHP] Looping through a Db query result twice in PEAR

Shouldn't it be; $sql="Some query"; $result = $conn->query($sql); //V VVV while ($row = $conn->fetchArray($result)) { echo $row['hey']; } // V VVV while ($row2 = $conn->fetchArray($result)) { echo $row2['otherhey'];

[PHP] Looping through a Db query result twice in PEAR

Greetings All, I have a problem that I usually solve in MySQL pretty easily, but using PEAR identifiers are not working. Any suggestions. I want to loop through a result set in two different while loops that are not nested. I am able to do in it MySQl as follows $sql="Some query"; $result =