I'm a bit of a newbie when it comes to CakePHP and MySQL and I'm not really sure about all of the terminology involved, so if this question has been asked before, I apologize.
I have three models: Skill Tree Link A Skill hasAndBelongsToMany Links. A Skill hasMany Trees. Under normal circumstances, a Skill should have at least 1 Link and 1 Tree. But there are valid reasons that a Skill may have 0 Links and/or 0 Trees (e.g. when the Skill is a work-in-progress), but the casual end- user of the site shouldn't really see these. Since there are currently 707 Skills, I use Paginator to display them. What I want to do is create some kind of Paginator query or condition that will only display Skills that have 1 or more Links and 1 or more Trees. (I know I could probably do it easily using a tree_count and link_count field in the skills table, but that'll be a lot of hassle to set up. I was thinking there might be some better way to use, say, a MySQL COUNT() function instead.) Any thoughts? Thanks for your help! Daniel --~--~---------~--~----~------------~-------~--~----~ 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] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
