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
