Web lists-archives.com

Re: [PHP] Report Summary Page Help Needed





On 10 March 2016 16:41:46 GMT+00:00, "dealtek@xxxxxxxxx" <dealtek@xxxxxxxxx> 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@xxxxxxxxx
>[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.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php