Re: [PHP] Working on a Subsummary Report

2011-12-19 Thread Jim Lucas
On 12/17/2011 4:21 PM, DealTek wrote: > > On Dec 16, 2011, at 12:56 PM, Jim Lucas wrote: >> >> >> 1) What does your db schema look like? >> 2) What SQL do you currently use? >> 3) What criteria do you want to use to sort the data? >> 4) Will the output be plaintext, html, etc? >> 5) Is this going

Re: [PHP] Working on a Subsummary Report

2011-12-18 Thread Jim Lucas
On 12/17/2011 6:14 PM, DealTek wrote: >>> >> >> for the above to work right, you will need to loop through the mysql result >> set >> one time. Placing all the results in to one large array. Then you can loop >> through the array as many times as needed. >> >> What you will probably find is that

Re: [PHP] Working on a Subsummary Report

2011-12-17 Thread DealTek
>> > > for the above to work right, you will need to loop through the mysql result > set > one time. Placing all the results in to one large array. Then you can loop > through the array as many times as needed. > > What you will probably find is that you can sort all the data into the proper

Re: [PHP] Working on a Subsummary Report

2011-12-17 Thread DealTek
On Dec 16, 2011, at 12:56 PM, Jim Lucas wrote: > > > 1) What does your db schema look like? > 2) What SQL do you currently use? > 3) What criteria do you want to use to sort the data? > 4) Will the output be plaintext, html, etc? > 5) Is this going to be used to import into another app, or displ

Re: [PHP] Working on a Subsummary Report

2011-12-16 Thread Jim Lucas
On 12/16/2011 12:56 PM, DealTek wrote: >> >> >> what about creating a master report that has the total summarized by >> category and then offering a drill thru type structure to dig deeper >> in certain areas? > > > > - Hi Bastien, > > That's a cool idea. In this case they want it on a longer s

Re: [PHP] Working on a Subsummary Report

2011-12-16 Thread Jim Lucas
On 12/16/2011 9:04 AM, Dave 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

Re: [PHP] Working on a Subsummary Report

2011-12-16 Thread DealTek
> > > what about creating a master report that has the total summarized by > category and then offering a drill thru type structure to dig deeper > in certain areas? - Hi Bastien, That's a cool idea. In this case they want it on a longer single page so they may save or print all at once. A

Re: [PHP] Working on a Subsummary Report

2011-12-16 Thread Bastien Koert
On Fri, Dec 16, 2011 at 1:49 PM, DealTek wrote: >> >> >> I would give consideration to the 'group by' function for your query, and >> loop through that. > > Thanks Mike - will do... > > -- > > *beginner question* - what would we call this type of query/display: > > reporting or summary or

Re: [PHP] Working on a Subsummary Report

2011-12-16 Thread DealTek
> > > I would give consideration to the 'group by' function for your query, and > loop through that. Thanks Mike - will do... -- *beginner question* - what would we call this type of query/display: reporting or summary or ? I'm not sure what terms look up? it would be similar to que

Re: [PHP] Working on a Subsummary Report

2011-12-16 Thread Mike Mackintosh
On Dec 16, 2011, at 12:04, Dave 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 sq

[PHP] Working on a Subsummary Report

2011-12-16 Thread Dave
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 querie