Hello. I have the problem with pagination. I need to paginate this
query but i dont know how to do it.

query:

SELECT cmx_posts.title, cmx_rates.name, count(cmx_posts_rates.rate_id)
FROM cmx_posts_rates
   INNER JOIN cmx_rates ON cmx_posts_rates.rate_id = cmx_rates.id
   INNER JOIN cmx_posts ON cmx_posts_rates.post_id = cmx_posts.id
  GROUP BY cmx_posts_rates.post_id,cmx_posts_rates.rate_id

-- 
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

Reply via email to