Totaling sales by month
| From: | Brian Dunning | Date: | Fri, 10 Sep 2004 22:01:34 +0000 |
| Subject: | Totaling sales by month | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-196368@lists.php.net to get a copy of this message | ||
I have a MySQL db with a datetime field containing the date and time of the sale. I want to query for a simple report that shows total sales by month.
I thought this would be quick & easy but it's NOT! I can't figure out how to query for it.
If this question would be better posed to a SQL list, I'd appreciate a recommendation to a good one. I couldn't find one via STFW that had any kind of volume.
- Brian