RE: best way to iterate through DB_Result the second time around?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Iterating over a result set is eaasy the first time;
> 
>   while( $group_data = $result->fetchRow( DB_FETCHMODE_ASSOC ) )
>   {
>  	blah.......
>   }
> 
> 
> How come DB_Result doesn't have a reset() function so you can iterate
over
> the result set a second time without having to resort to this sort of
> thing?
> 
> for( $i = 0; $i < $result->numRows(); $i++ ) // Have to iterate
through
> 
>                                               // result set on the
second
> pass
> {
>         $group_data = $result->fetchRow( DB_FETCHMODE_ASSOC, $i );
> 	blah......
> }

It depends on your database... If you're using MySQL, see if whatever
class you're using has a wrapper for mysql_data_seek(). It will do what
you want rather easily. 

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux