ADO: .movefirst ?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Question : How can I iterate more than once over a query resultset ?

Usually this is how I connect to my odbcdatabase (classic stuff) :

while ($row=odbc_fetch_array($object) {



Now suppose I want to loop through it again, how do I reset the pointer to
the beginning ?
I realize doing $row[]=odbc_fetch_array is an option.



Re: ADO: .movefirst ?


Quoted text here. Click to load it

Afaik, odbc_exec (preferably using odbc_prepare) or your suggestion are  
the alternatives you have.

Using postgre you could use pg_result_seek..

Using Opera's revolutionary e-mail client: /

Site Timeline