Re: Report Summary Page Help Needed

On 10 March 2016 16:41:46 GMT+00:00, "dealtek@gmail.com" <dealtek@gmail.com> wrote: >Hi all, > >As an example, I have a page where the user can select a few products, >then I have a database PHP MySQL query that selects recent purchases of >those products and also where they were purchased from like: > >- query... select widget1 - widget2 and widget3 > > >RESULT... > >widget1, invoice 51, sold from store 1 >widget1, invoice 72, sold from store 2 >widget1, invoice 59, sold from store 1 > >widget2, invoice 2, sold from store 2 >widget2, invoice 81, sold from store 1 > >widget3, invoice 201, sold from store 1 >widget3, invoice 151, sold from store 2 >widget3, invoice 17, sold from store 2 >widget3, invoice 3, sold from store 1 > > >- I would like to generate report that can do some summary functions, >so that the output report looks something like: > >'SHOW PRODUCTS with STORE SUMMARY' > > >STORE 1 > >widget1, invoice 51, more fields here >widget1, invoice 59, more fields here >widget2, invoice 81, more fields here >widget3, invoice 201, more fields here >widget3, invoice 3, more fields here > >STORE 2 > >widget1, invoice 72, more fields here >widget2, invoice 2, more fields here >widget3, invoice 151, more fields here >widget3, invoice 17, more fields here > > >--> I am curious how to construct the php to be able to simulate this >'STORE SUMMARY' on the report page. Any ideas are welcome. > >THANKS IN ADVANCE - Dave > >-- >Thanks, >Dave - DealTek >dealtek@gmail.com >[db-16] Without seeing any code, it's a little difficult to offer any advice. Do you have a sample case that illustrates what you're already doing? Thanks, Ash -- Sent from my Android device with K-9 Mail. Please excuse my brevity.