Re: query

On Oct 30, 9:50 am, SERKAN TURAN <serkantu...@gmail.com> wrote:
> Hi,
> I have an query and I could not figure it out what is the cakephp form of
> it.
>
> query:
> -------------------------------------------
> SELECT *
> FROM
>   tags`
>   INNER JOIN `tags_articles` ON (`tags`.`id` = `tags_articles`.`tag_id`)
>   INNER JOIN `articles` ON (`tags_articles`.`article_id` = `articles`.`id`)
> WHERE
>   `articles`.`isRead` = 'Not' AND
>   `tags`.`id` = 3 AND
>   `articles`.`status` = 'New'
> ORDER BY
>   `articles`.`name` DESC
> --------------------------------------------------------------------------- -------------------

Serkan,

Your question is almost the same as the example in the book.

See "It's also possible to create an exotic association for the
purpose of creating as many joins as necessary to allow filtering, for
example:"
http://book.cakephp.org/view/1044/hasAndBelongsToMany-HABTM

have a go and post a follow up if you do not succeed. Tip: search from
Article, not Tag.

AD

--
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