What you get from the CakePHP pagination helper is reason enough to use the CakePHP framework. However, what happens if you need to paginate results from multiple tables? I’ve set up a working demo to show an approach and have provided project files for download. In the app folder of the project files you’ll find a paginatedjoins.sql file to set up your tables. Remember to provide your own credentials in your config/database.php file.

(more…)