partial sending many records: result of the query
Posted: Wed Apr 04, 2007 6:49 am
hi!
imagine suche a senario:
a database on the server.
a client run a query, the result of which is 300 records.
php must send only 30 records, but at the page, include links like this:
31-60
61-90
91-...
so that the client can continue recieving the whole result of his query.
I know how to run a query on the server, and get and send the result.
but I wonder, what the right technique is, to deliver many records by part, without every time to run the query again on the server.
help!
imagine suche a senario:
a database on the server.
a client run a query, the result of which is 300 records.
php must send only 30 records, but at the page, include links like this:
31-60
61-90
91-...
so that the client can continue recieving the whole result of his query.
I know how to run a query on the server, and get and send the result.
but I wonder, what the right technique is, to deliver many records by part, without every time to run the query again on the server.
help!