Okei, so I have a HABTM setup: - posts - tags - posts_tags When creating posts => select multiple tags: example: Tag1, Tag2, Tag3
Each selected tag is saved to posts_tags: id:1, post_id: 44, tag_id: 3 (and so on). Now, displaying my posts, and listing the selected tags, is no problem. Everything is working flawlessly. However, I would like to have widget "You might also like these posts" => list 5 posts with similar content (using the same tags as the post beeing read). So here I came across some difficulty finding similar posts according to selected tags. Example: Is *Post.id = 44 * (beeing read) have *Tag.id = 1, 3 ,4 *assigned How can I retrieve *5 other posts* that have the same *Tag.id assigned*, and *exclude the Post.id beeing read* from the find?? I guess I will need to use some kind of join/grouping, but I am a total noob regarding those things, so any help on this will be GREATLY appreciated!! Thanks for your time! -Tom -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
