Web lists-archives.com

[PHP] Report Summary Page Help Needed




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@xxxxxxxxx
[db-16]