Sorry I didn't understand your reply
I have defined the relationship
class UsersLink extends AppModel {
var $belongsTo = array(
'Link' => array(
'className' => 'Link',
'foreignKey' => 'link_id',
'conditions' => '',
'fields' => '',
'order' => ''
),
'User' => array(
'className' => 'User',
'foreignKey' => 'user_id',
'conditions' => '',
'fields' => '',
'order' => ''
)
);
}
What do you mean by "joining table should be links_users (i.e. the
tables are in alphabetical order)" ?
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
