argh gmail hotkeys irritate me... continuing mail... ----
Im trying to leave as much up to the sql server as possible and reduce the number of separate queries I run. I could probably accomplish all of these reports with 100's of queries all handled in the controller but that would get progressively slower should the db fill up... thanks! On Thu, Oct 15, 2009 at 4:54 PM, Bryan Paddock <[email protected]>wrote: > 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 -~----------~----~----~----~------~----~------~--~---
