Trouble getting results with this query
 

For the life of me I can't get this to return any results other than 0. It works great in phpmyadmin though.

Note: I had to attach it in a txt file because it makes the post go to a blank page no matter what bbcode I wrap it in.

Not sure if this would be your problem or not, but try changing the variable name of the query to $months and adding a line below it:
$month = mysql_fetch_array($months);
As far as my experience goes, queries don't return as associative arrays by default.

Shouldn't this code be changed?
To:
Because you define the count as posts here:
- Zero Tolerance

Ahh.. I knew someone would spot it, thanks!

Also you are mixing single quotes and double quotes in the query statement.