paginator on a sigle HABTM relation can be seen on
http://cakebaker.42dh.com/2007/10/17/pagination-of-data-from-a-habtm-relationship/

But Imagine that users can subscribe to categories
so: Product HABTM Category HABTM User
If we would like to paginate through the products in the users
categories how can this be done ???

The sql would be like
“select products.* from products,categories_products as
cp,users_categories as uc WHERE products.id=cp.product_id AND
cp.category_id=uc.category_id AND uc.user_id=$User[id]”

But how would one define the model ???



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to