Displaying the next record on web page without executing query again

[RedRocky]

What is the best way to display the next record on a web page, from a list of records, without executing the query over and over again each time you display the next record?

 

For example, imagine my user has a list of messages displayed on a web page, and the user filters that list to display all messages with the title "Test", and let's say that returns 12 records.

 

He then clicks on record 1 to read that message. Once he is done reading it, he then wants to read msg 2, and then msg 3 etc.

 

He could hit the Back button in his browser and click on the next record from the list, but it would be more useful to just click on a link that says "Next" which displays the next message in the filtered list of messages (without having to go back to the list).

 

A lot of web sites do this sort of thing, but what is the best way to do it? Do you have to run the original query again each time a new message is loaded, so you know which message is next, or can you somehow store the query to save the server from having to run the same query over and over again?

 

If a user is viewing a list of pictures for example, they could be flicking through the pictures quite quickly, and I would not like to have the server running the same query over and over again every few seconds when it doesn't need to.

 

Advice? (Thanks.) 

[litebearer]

store the info in an array

[dolrichfortich]

Try this one http://benmetcalfe.com/blog/2005/12/mysql-database-caching-in-php/.