Friday, February 24, 2012

Problem with PaginatorHelper

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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: