Hi everyone, I have ReportsController which paginate rows between selected time span (for example, previous / current month, year). Exemplary query look like "SELECT DATE_FORMAT(User.created, "%Y") AS User__date, COUNT(*) AS User__count FROM `store`.`users` AS `User` WHERE YEAR(`User`.`created`) = '2012' GROUP BY YEAR(`User`.`created`) ORDER BY `User`.`created` asc LIMIT 20". Everything works for me but when I choose to show data from current month and group it by months it gives 1 results but shows 7 pages in Paginator::numbers function, why?
Thx in advice, Łukasz -- 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
