You would need to use MySQL's COUNT() and GROUP BY functions to achieve that at a database level.
HTH, Paul. On Oct 7, 11:27 am, Xoubaman <[email protected]> wrote: > Missclicked publish when writing ¬¬ > > The point is get the desired array without looping through the entire first > array. > > Maybe is possible to begin with a better formatted array, i'm using this > find to get it: > > $articles = $this->Article->find('all', array( > 'fields' => array( > 'YEAR(Article.publish_date) as year', > 'MONTH(Article.publish_date) as month'), > 'order' => array('year DESC, month DESC')) > ); -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
