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@gmail.com [db-16]