results on multiple pages: storing search results or query again

[koen]

Suppose I have a search result with different pages. I could store the results and get them out of the database with a simpler query for the next page. Or I could query again and display only a portion of the results (eg from 20-30). What would be the most efficient. How would bulletin boards do this, or google?

[jazz_snob]

only query for 1 page worth of records---lots of tutorials and sample code laying around cyberspace: http://www.php-mysql-tutorial.com/php-mysql-paging.php

[koen]

That link is certainly interesting. Learned things from it. I'm far from a security expert but I think the example is a bit unsafe, since they don't filter the $_GET.