Complicated query on very simple database - pointers sought
| From: | George Pitcher | Date: | Wed, 22 May 2002 12:45:02 +0000 |
| Subject: | Complicated query on very simple database - pointers sought | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19354@lists.php.net to get a copy of this message | ||
Hi all,
I want to report some figures to my colleagues.
My database (2 fields: Customer, Order date) contains over 15000 records
dating back to 1999.
I want to be able to show, in a web page, the following information
Month Customers placing orders Orders placed
Average Orders/Cust Average over prev 12 months.
My work with MySQL has never been this detailed.
Can anyone give me any pointers?
Regards
George in Edinburgh