help me !!!

[Anon]

Database : Oracle8.1.6
Version : PHP4.0
I want to displsy the data with pages, one page display 10 record, but the Oracle seem to be no the functon: "Limit $offset," same as the MySQL.
my SQL: "select id from tbl_name where sort='$sort' order by time_val desc"

Can you help me ?
or give me a example ,thanks!

[Anon]

Hi,
I don't know if I'm right but my suggestion is that u can achieve the same programmatically.

• Select 10 record from the database and display them and in the program set a counter too.So first time it would be one.
• During the next selection, select records ranging from 11 to 20,which is (counter)10 to (counter+1) 10
• The records can be identified by having an autoincrement field so retrieve all the records whose autoincrement field value like counter10 to (counter+1)10

The satement would be like this
for($i=1;$i<=10;$i++){

$query="Select from tablename where autoincrementfield=(counter10)+$i"
....
query processing steps...
}

Hope this may solve ur problem.

[Anon]

Also, if you don't have sequentially numbered records you can do the rather more nasty trick of returning the whole result set on each page then doing fetch_row() through it, displaying nothing it until you get to the records that are vaild for the current page.