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 nested.
> 
> I am able to do in it MySQl as follows
> 
> $sql="Some query";
> $result = $conn->query($sql);

I'm not sure how this is mysql specific. it appears that this is
some class you are using.

> 
> while ($row = $result->fetchArray()) {
>       echo $row['hey'];
> }
> 
> while ($row2 = $result->fetchArray()) {
>       echo $row2['otherhey'];
> }
> 
> This has worked in the past and I do not have to hit up the DB twice for 
> the same information.

The class you are using probably does some caching of the result so
you are able to do this.

> 
> However when I try something similar with PEAR it does not work.
> So the below does not work. This is my first time using PEAR.
> So can anyone help me out.
> I cannot seem to find anything about this on the documentation online.
> 
> $sql="Some query";
> $result = $db->query($sql);
> while($result->fetchInto($data)) {
>               echo "\t\t\t<li><a 
>               href=\"#$data[id]\">$data[question]</a></li>\n";
> }
> 
> while($result->fetchInto($data2)) {
>               echo "<a name=\"#$data2[id]\">$data2[answer]</a></li>\n";
> }

This is sort of expected with any interface, if you want to start
over you would probably have a $result->seek() call resetting the
result  to the beginning of the result set. I dont think pear
has such a thing.  The pear mailing list might be more helpful.

Curt.
-- 
cat .signature: No such file or directory

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to