I have an almost identical application, but I am using Apache::ASP instead of PHP.
Apart from the language differences, I
suspect the ideas are the same.
What I have done is store the *entire* list of results in a session variable with a
clock-time. When I get a new query
(...?page=2), I check i
Sort of depends on the nature of your application. You can use offset to get
specific chunks:
select * from foo order by date limit 100 offset 100;
You should be aware, however, that on a very large table this can be quite
inefficient as you will have to do the select and sort on the large tabl
