On 2 Apr 2004 01:00:41 -0800,
ch****@volny.cz (chripa) wrote:
I use php with oracle database and i need function like mysql_data_seek
i need to set the result pointer to the row number I need.
can anyone help me?
There isn't one. If you want to go backwards, save your rows in PHP array and
use that instead.
Oracle 9i's OCI supports "Scrollable Cursors" which would allow you to go back
and forth through result sets, rather than the normal and more efficient
forward-only streaming of rows as soon as they're available. But PHP hasn't
implemented support for them, unless it's been added very recently.
The Oracle manual also states:
"Note:
Do not use scrollable cursors unless you require the functionality, because
scrollable cursors use more server resources and can have greater response
times than non-scrollable cursors."
What is the problem that you are trying to solve that requires seeking back
through the result set?
--
Andy Hassall <an**@andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk /
http://www.andyhsoftware.co.uk/space