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 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 > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php