execute query in the last page with pagination

saber

Hello,

I want to retrieve 200 line from but I display just 10 line for page and when I'm in last page I load from DB other 200 line.
And sorted it for 200 line not for all DB.

for example I have 400 line in DB:
I would like execute 2 query in DB Limit 0,200 and 201,400.
and each query I have pagination and sort from this resulat and when I go in the last page I can execute query from Limit 201,400

Thank you

allan

Have a look at this example: http://datatables.net/release-datatables/examples/server_side/pipeline.html

Allan