Codes here !
3 posts • Page 1 of 1
You're having issues because you're pulling a scalar value, and grouping on an aggregate. Change your select to read '$query = "SELECT MONTH(EXPDATE),SUM(ORDTOTAL) ";' etc, and you should be fine, except that you're probably going to have bad data if you have data for 11/11 and 11/12. so you could select and group by YEAR(EXPDATE),MONTH(EXPDATE). You also don't need to include your sum(ORDTOTAL) in the group by.