Re: hasMany with group by

On Tue, Mar 12, 2013 at 3:33 PM, André Luis <cavallari@live.com> wrote:
> Hi people, I have model User and model Image, and the model User hasMany
> Image, so when i use $this->User->find('all'), it comes with the respective
> related images, but in the table of model Image, I also have the field
> "category", wich is a string... My doubt is, is there anyway to group the
> results of the related model "Image" by the field "category" at the related
> model "Image" ??

With hasMany you can use a finderQuery:

http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#hasmany

However, in this case I suggest you instead use a Category model:

User hasMany Image
Image belongsTo Category (or HABTM for more freedom)

You might find it easier to work with a Gallery model as well.

--
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 unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.