Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Anis Ahmad's Blog:
Join Problems with Zend_Paginator and Zend_Db_Select objects
Aug 28, 2008 @ 12:18:55

Anis Ahmad had a problem. The Zend_Paginator component of the Zend Framework, while powerful, wasn't quite working right. Bugs popped up when he used a join along with a Zend_Db_Select.

One of the 4 Adapters for Zend_Paginator is DbSelect which uses a Zend_Db_Select instance. Now, the problem occurred if I need to have some calculative data from other tables and use join with the Zend_Db_Select object for them.

He gives an example of a join that he performed with the component, the details of the "behind the scenes" code and why it happened that way. He also offers a solution (before the Zend_Pagination component was patched for it, of course) of changing the count() method it uses slightly to remove an unneeded part of the query.

tagged: zendpaginator zenddbselect component zendframework

Link: