[PHP] Totaling sales by month

[Brian Dunning]

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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php