This is one way I found it to be working with find('all') but not with
paginate ( due to the select count)
$this->User->recursive = -1;
$options['joins'] = array(
array('table' => 'users_links',
'alias' => 'UsersLink',
'type' => 'inner',
'conditions' => array(
'User.id = UsersLink.user_id',
'UsersLink.inbox = 1'
)
),
array('table' => 'links',
'alias' => 'Link',
'type' => 'inner',
'conditions' => array(
'UsersLink.link_id = Link.id'
)
)
);
$options['fields' ] = array('Link.id', 'Link.title');
$inbox = $this->User->find('all', $options);
What do you think?
On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit
<[email protected]> wrote:
> If you have defined a HABTM relationship your joining table should be
> links_users (i.e. the tables are in alphabetical order).
>
> Jeremy Burns
> Class Outfit
>
> http://www.classoutfit.com
>
> On 21 Jul 2011, at 16:26, localhost wrote:
>
>
>
>
>
>
>
> > Hi everyone,
>
> > I have being trying to solve this for the last 4 hours with no luck.
>
> > basically I have the following tables
>
> > users
> > links
> > users_links
>
> > Basically I'm trying to get the below query to run using find('all')
> > and paginate (I'm running this inside UserController)
>
> > SELECT Links.id,Links.Title FROM users,links,users_links WHERE
> > user.id=1 AND user.id=users_links.user_id AND
> > users_links.link_id=links.id AND users_links.index=1
>
> > (see the above sql "users_links.index=1").
>
> > how to get this working ?
>
> > --
> > Our newest site for the community: CakePHP Video
> > Tutorialshttp://tv.cakephp.org
> > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help
> > others with their CakePHP related questions.
>
> > To unsubscribe from this group, send email to
> > [email protected] For more options, visit this group
> > athttp://groups.google.com/group/cake-php
--
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
