Creating monthly reports

While the flash graph on the top of the admin in PS is nice, I want to create something a little differently. I want to be able to compare November 2012 results with November 2013. Playing around with it I was able to pull all the order totals from any given month, one by one. But that doesn't give me a sum, which is all I'm really after. I don't need anything super complicated as I can just write a query for each month of each year, set up in a table format for client to view easily. I don't know how to get the sum.

Here's how far I got with January 2012, order listed by order.

$query_jan12 = "SELECT * FROM ps4_orders WHERE OrderDate LIKE '2012-01%'";
$jan12 = mysql_query($query_jan12, $mmsstore) or die(mysql_error());
$row_jan12 = mysql_fetch_assoc($jan12);
$totalRows_jan12 = mysql_num_rows($jan12);

Any pointers, most appreciated. Thanks!

Getting closer. I can get a sum of ALL orders with this

SELECT SUM(OrderAmount) FROM `ps4_orders`

:-) So now to add in the date…

Got it!

"SELECT SUM(OrderAmount) FROM ps4_orders WHERE OrderDate LIKE '2012-02%'";

:-)

attaching a screen shot of my project… just to clarify what I was trying to do. Hope it helps someone else. It is a live feed of information upon refresh.

Glad to see you figured it out.