PEAR::DB question

["Jacob Marble" <jacobmarble@landez.com>]

Hello-
    I'm using the fetch method to get a result set.  ie-

$sql = "select id,name from sr_names order by name";
$result = $db->query($sql);
while ( $row = $result->fetchRow(DB_FETCHMODE_ASSOC) )
    echo $row['id'] . ' ' . $row['name'] . "<br>";

    This works great!  Now, I want to _re-use_ this result set without
having to re-query the database.  Then cycle through the result set.  ie -

$result->someFunction();
while ( $row = $result->fetchRow(DB_FETCHMODE_ASSOC) )
    echo $row['id'] . ' ' . $row['name'] . "<br>";

    So, the output here would be two of whatever was output.  Does that make
sense?  Right now I'm having to do this:

$sql = "select id,name from sr_names order by name";
$result = $db->query($sql);
while ( $row = $result->fetchRow(DB_FETCHMODE_ASSOC) )
    echo $row['id'] . ' ' . $row['name'] . "<br>";
$result = $db->query($sql);
while ( $row = $result->fetchRow(DB_FETCHMODE_ASSOC) )
    echo $row['id'] . ' ' . $row['name'] . "<br>";

    If I already have the result set, can't I just tell it "hey, put the
cursor back at the top".  I know I can fetchRow from a specific row in the
result set, but then I'd have to get every row that way, which doesn't make
efficiency sense, either.
    Thanks in advance,

Jake

LandEZ



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