Lee Blue has posted a handy tip for users of the Zend Framework, specifically when sorting the results from a query to tables linked in a Zend_Db_Table setup.

So you figured out how to define the relationships between your Zend_Db_Tables and you have issued a call to findDependentRowset(). You get your Rowset back but you need to sort the results by one of the columns in the dependent table. How do you do that?

Unfortunately, he's found out that you just simply can't - well, not without a custom function (until the 1.5 release of the framework rolls around). He shows his table set up and some sample database classes to relate to the tables (and link between them). The magic comes in with his DU_Utils class that takes in the data and sorts it based on the given column name in the given direction.

This month's edition of php|architect magazine has been released - the January 2008 edition. Articles included in this month's issue include:

• PHAR: PHP Archive Files from Gregory Beaver
• Webmail 2.0: Introducing RoundCube by Tim Klampackel
• Killing the For Loop from Paul Chandler
• The Doctrine Framework by Nicolas Berard-Nault
• and the usual columns - /Etc and Test Pattern

If you're already subscribed, you should be getting your issue any time now but, if you're not, there's two ways you can get your hands on a copy - either "quick buy" it from the php|architect website or subscribe and get this and other great future issues jam packed full of great PHP content.