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

Debuggable Blog:
How to do Group By conditions in Model find() calls in the CakePHP RC1
Jun 12, 2008 @ 09:48:09

On the Debuggable blog, Tim Koschutzki shows how to use grouping in your SQL statements with the find() method calls inside of a Model for an app.

We have to thank Mark Story and wluigi for working on group by conditions for Cake's Model::find() method. Up until now, you would have to add your GROUP BY stuff to string'ed conditions in order to support a group by statement, which could be very ugly.

He has some code included that compares the two methods - the newer of the two applying the 'group' option as a regular condition to the query object.

This functionality is currently only in the the Release Candidate 1 but will be included in the next major release.

tagged: cakephp framework groupby grouping conditional paginate

Link: