Caching MySQL queries

Question

Is there a simple way to cache MySQL queries in PHP or failing that, is there a small class set that someone has written and made available that will do it? I can cache a whole page but that won't work as some data changes but some do not, I want to cache the part that does not.

Answer 1

This is a great overview of how to cache queries in MySQL:

• The MySQL Query Cache

Answer 2

You can use Zend Cache to cache results of your queries among other things.