Welcome to Cake. The secret is to (in this order): 1) build your database tables to the conventions (lower case plural table names, `id` and `name` fields etc) 2) create indexes and referential integrity in the database 3) build your Cake models - you can use Bake for this as its pretty good, or do it yourself 4) learn and implement the Containable behaviour (it's much more powerful, controllable and friendly than relying on recursive)
Your Cake models echo the database joins using $belongsTo, $hasMany and $hasAndBelongsToMany. So, to use the good old blog model, a Post can have many comments ($hasMany), a Comment belongs to a Post ($belongsTo), a Tag has many Posts and a Post has many Tags ($hasAndBelongsToMany), and so on. To see your Posts with associated Comments and Tags you do this search: $posts = $this->Post->find( 'all', array( 'contain' => array( 'Comment', 'Tag' ) ) ); This will give you an array with an element for each Post, and nested in it an array with its Comments and Tags. You can then read these out and display them on your index view. To get the count of comments you can either do a count of comments from within the array, or use the counterCache function. This adds a comment_count field to your posts table and Cake will keep that up to date as Comments are added and removed to the database through the website (it can't track changes made directly in the database, or course). Pages that might help: http://book.cakephp.org/view/903/Model-and-Database-Conventions http://book.cakephp.org/view/1323/Containable http://book.cakephp.org/view/1042/belongsTo (has some details on counterCache) Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 25 Jun 2010, at 12:30, pswiggers wrote: > Hi, > > I'm new to cakephp , still really a lot to learn about it, but already > convinced cake is a good thing. > > So this is what I'm struggling with; > On my website I can list all my posts via the index function ($this- >> Post->recursive = 0). > But I've also comments and tags I already want to show on the index; > meaning number of comments (a count) and a list of tags. I can see > this data via the view function, but that requires an ID. As I can see > all data in the view for an ID I assume I build the tables (and > models) following cakephp convention. > Long story short: How could I to use the index but with related > information or the view but for all posts (not specific ID)? > > > Kind regards, > Patrick > > > 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+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php?hl=en 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en