Re: some search problem with many table

this is my sql query:

SELECT
users.username,
users.id
FROM
users
INNER JOIN usercats ON users.id = usercats.user_id
WHERE
users.shahr_id = 576 AND
usercats.subcat_id = 1

i dont understand how can i config this query in other
Controller(SearchController)
help me step by step,i am new in cakephp

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en