Trouble getting results with this query

[ericgtr]

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.

[Kaezul]

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.

[Zero Tolerance]

Shouldn't this code be changed?

$month['count']

To:

$month['posts']

Because you define the count as posts here:

COUNT(postid) AS posts

- Zero Tolerance

[ericgtr]

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

[Marco van Herwaarden]

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