If you have author's id then to find all books for that author ordered/sorted by categories, you can also do, Category->findAll("Book.author_id = $author_id", null, 'Category.name ASC');
On 10/19/07, BoSc <[EMAIL PROTECTED]> wrote: > > > You're right, in Cake lingo this is called HABTM, in normal database > ERD's they both have a Has Many relationship with eachother.... > ofcourse I have modeled this with HABTM, but thanks for your > correction! > > Your solution to the order problem is 'spot on', actually what I was > looking for! I didn't knew that this was possible from within the > model. > > GriGri, thanks for elaborating on the FindByFieldname() function, I > was using findBySlug() for ages, and was already wondering by this > wasn't in the API... LOL.... just some more Cake magic indeed! > > On Oct 18, 11:30 am, "Amit Badkas" <[EMAIL PROTECTED]> wrote: > > On 10/18/07, BoSc <[EMAIL PROTECTED]> wrote: > > > > > > > > > Hi, > > > > > I've got 3 tables with a 1:n relationship: > > > > > - author (has many books) > > > ^ > > > | > > > | > > > V > > > - books (belongs to categories) (has many authors) > > > > - I think you made a mistake here, actual relationships may be author > HABTM > > books and books HABTM authors > > > > | > > > > > > > > > | > > > V > > > > > - categories (has many books) > > > > > What I would like to do on one page, is show a categorized view of all > > > books by a specific author. The problem lies in the fact that each > > > category and each book also has some kind of sorting involved, which > > > states at what place in a category a book should be shown... > > > > > >From which Point of View should I query this, and am I able to > > > implement this in 1 query? > > > > > What I would like to end up with is the following array > > > > > array > > > category 2 > > > book 1 > > > name > > > blabla > > > book 3 > > > name > > > blabla > > > book 2 > > > name > > > blabla > > > category 1 > > > book 4 > > > name > > > blabla > > > book 6 > > > name > > > blabla > > > book 5 > > > name > > > blabla > > > > > The problem is, when I use findAll on Category, I'm not able to choose > > > how Cake should order the Books. Any workarounds? > > > > - Use Category->findAll(null, null, 'Category.name ASC'); and in > category > > model, define hasMany relation with book like, $hasMany = array('Book' > => > > array('order' => 'Book.name ASC')); > > > > -- > > Regards, > > Amit > > > > > http://amitrb.wordpress.com/http://cheesecake-photoblog.org/http://www.sanisoft.com/blog/author/amitbadkas > > > > > -- Regards, Amit http://amitrb.wordpress.com/ http://coppermine-gallery.net/ http://cheesecake-photoblog.org/ http://www.sanisoft.com/blog/author/amitbadkas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---