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.