Basically I'm just looking for a little finger pointing in the right direction... output of a submission - http://pastebin.com/f221f94c1
I'm trying to do some reporting based on a few related model fields eg by school, by country, by category etc. each must also be grouped by all the years too. I'm dreading the submissions by week report... Any pointers would be great... I'm trying to leave as much up to the sq On Thu, Oct 15, 2009 at 4:18 PM, Bryan Paddock <[email protected]>wrote: > Hey guys, > I'm trying to figure out how best to go about doing reports for my current > project. > > It's a website where artists upload their work and then judges make rate + > comment etc. My query is in the reporting section. > > The main model is the Submission model. > > Submission belongsTo Student, Category, Competition > Student belongsTo User, Country > > I'm trying to find out how to group by school (Student.school field). Each > submission is tied to the student row by a Submission.student_id field. > > ie show each unique school and how many submissions there are for that > school. > > Thanks, > Bryan > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
