HABTM again!

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