PEAR::DB & persistence??

Using PEAR::DB w/ Postgres -- I'm finding that once I fetch rows from a DB result set, the result set is empty. See example code below. Is this the expected behavior or am I missing something? Thanks Graham Using the following code example -- var_dump($a) is as expected var_dump($b) is empty

        $sql    = "SELECT * FROM myTable";
        $result = $db->query($sql);

        $a              = array();      // array to hold data
        while ( $mydata = $result->fetchRow(DB_FETCHMODE_ASSOC)) {

                        $thisdata = array(
                                        'col_1'         => $mydata['col_1],
                                        'col_2'         => $mydata['col_2],
                                        'col_2'         => $mydata['col_2]
                                          ); 
                $a[] = $thisdata;
                }

        $b              = array();      // array to hold data
        while ( $mydata = $result->fetchRow(DB_FETCHMODE_ASSOC)) {

                        $thisdata = array(
                                        'col_1'         => $mydata['col_1],
                                        'col_2'         => $mydata['col_2],
                                        'col_2'         => $mydata['col_2]
                                          ); 
                $b[] = $thisdata;
                }

Graham Clarke GrahamC@53Tech.com www.53Tech.com 603.643.9955