Spanning search results

Anon

Can anyone give me some tips on spanning search results across pages? I have a page that returns a sql result 1 at a time and I want to do the 1 query and pass it along so I don't need to query the DB each time. Any advice?

Thanks

George Loch

Anon

Put all of your query results into an array and use a session to hold that data. Then just access it from every page.

Or build a large hidden form and use buttons to submit the form to the next page only displaying the results that you want to.

Or use a session like capability by storing the results of a query in a file on the system and make each link to your other pages use that file for it's data.

I'm sure there are more ways to do this, just think about it awhile I'm sure you'll come up with the right answer.

Anon

this problems almost always ends up by caching all the result pages every 10 minutes using a cron job.

if you don't want to query the database on the 2nd page, and don't care if the data is already old by the time you get to it, then why do you query the database on the 1st page!

just follow ebay, google, yahoo and countless other major sites and cache your result sets. just set up a cron job to do it every 5 minutes or something.