On Dec 16, 2011, at 12:04, Dave <dealtek@xxxxxxxxx> wrote: > Hi all, > > I need to create a year to date report with individual Subsummary > Report (ala filemaker / others?) headings for each month. So, I’m > curious the best way to approach this for performance speed and > flexibility etc. > > - I can do 1 sql query for the whole year’s data - or 12 individual > queries... probably best to do 1 big year sql query - but I’m not sure > how to split things up with loops etc. > > each summary month heading will need to show: > - total month count of records > - special counts within each month > - more stuff > - also the record data > > like: > > JAN - total record count = 50 special count = 3 > > data record 1 > data record 2 > data record 3 > > FEB - total record count = 47 special count = 4 > > data record 1 > data record 2 > data record 3 > etc. > > > Q: is it better to do 1 year find or 12 month queries - is 1 big find faster? > > Q: with one year find - how do I setup 12 loops to simulate summaries? > do i just loop through the full set and only display if record is in > month 1 or 2 or whatever? > > If there are any links describing this process - that would be great > > any help would be appreciated... > > > -- > Thanks - Dave > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > I would give consideration to the 'group by' function for your query, and loop through that. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
