Newbie using DB2 - Pagination without LIMIT

[decibel-X]

Need some assistance regarding a unique setup we have onsite. I come from a mySQL background, and I'm trying to paginate the results of my database queries, but LIMIT is not supported by DB2 (which is what we are using). Is there anyway to paginate the results of my query within PHP?

[bastien]

DB2 has the rowid structure. You could sort the data and capture the last rowid value and use that value to control the next recordset call

ie

1st call

select * from table where [certain crtieria]

2nd call

select * from table where [certain crtieria] and rowid> $last_rowid

[tekky]

or simply...

$page = 5; //random # i just picked
$num_per_page = 10; //another random # i used
//select statement would be like
$query = "SELECT * FROM table WHERE columnID > ($page * 10) AND columnID < ($page * 10 + $num_per_page + 1)"

then just increment $page by one, and you will get the next 10 entries....

so this would produce

everything > 0 and < 11 ie, 1-10
then > 10 < 21 ie: 11-20
...
...
...

50 < 61 ie: 51-60

[decibel-X]

Thanks all - I will give that a try!

[decibel-X]

Hmm...

Results from my query analyzer: (SQL error: Comparison operator > operands not compatible., SQL state 42818 in SQLExecDirect)

Nonetheless, your suggestions have pointed me in the right direction!

😃