As you all know, PHP is stateless. Meaning that once the script ends, all connections 
are closed and the program is done.

I have a project where I need to do just 1 query to oracle, but only get one row per 
page. So on the first page it does the query and says "20 results total" and shows the 
first selected row. Then I click next and it brings up the second row. I'm only 
supposed to show one row at a time. I can probably cheat and parse the query on each 
page, but I'd like to find out from you nice folks if its possible to do it with just 
one query. My guess is that I would be using a persistant OCI connection and an oracle 
package/procedure, but I'm not familiar with either of those enough to know if its 
possible or not. Or maybe I could store my parsed query in a PHP4 session? Thats 
another thing I am not very familiar with at this time.

Any info would be helpful. This project is due on wednesday so I need the help ASAP.


- Doug Schasteen

Reply via email to