Page 1 of 1

partial sending many records: result of the query

Posted: Wed Apr 04, 2007 6:49 am
by php77
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!

Posted: Wed Apr 04, 2007 7:20 am
by kpraman
are you asking about pagination?

Posted: Wed Apr 04, 2007 8:53 am
by Kieran Huggins
look into the MySQL "LIMIT" keyword