Need help in PHP / Oracle 10g pagination

Hi

can any one help me to write the code for PHP/oracle 10g pagination. i need Code for that..

Thanks
Sam

 

do you know how to query your records?

 

i know sql Query..

i need PHP/Oracle 10g code.

so i can implement those stuffs.
$conn = oci_connect('x2esaDB', 'er231as', '//lslsa.ssos.ssspx.com/XE');
$query="SELECT * FROM USER_DATA" ;
$stid = oci_parse($conn, $query);
oci_execute($stid);


Thanks
Sam

 

when i paginate my records i limit the search result

$query = "select * from tablename where .... limit (0,10)";

then i just increment the value of the limit...

 

Limit Function doesn't work with oracle Database.. it works for Sql Server & mysql.

thanks
sam

 

I'm working with Oracle in PHP but all queries I get from a real specialist in Oracle. I have pagination queries to in my project and they all look like described on oracle website.
Hope this helps