getting data from 2 tables based on a linked table

Hello all,

I don't really know how to describe this situation, but here is what i
wanna do. i have two tables in the database, contacts and groups,
which are linked together by a third table, groups_contacts (this one
has foreign keys of the first two tables). now i want to retrieve for
each group, the corresponding contacts. i'm trying to do this from the
contacts controller because i want to display these contacts based on
different conditions, one of them beeing the group. also i couldn't
find a solution on how to do these using $this->paginate() :|. i think
that's all. any help is welcomed :) thank you.
--~--~---------~--~----~------------~-------~--~----~
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 cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---