MySQL Group by Date (M, Y)

Databases
1

Hi huys,

I have a quick question and the right solution seems to elude me so far.

I have the following table for site statistics (views and clicks for a particular section or object in my site)


stats_object - object1, object2
stats_type - clicks, views
stats_time - timestamp

I wish to grab the # of clicks for object1 for each month every year. The query I have is not right. Please help.

SELECT COUNT(*) as mviews , MONTH(
FROM_UNIXTIME(`stats_time`) ) as mmonth, YEAR( FROM_UNIXTIME(`stats_time`) ) as myear 
		FROM `mytable`  		
WHERE stats_object='object1' 
GROUP BY MONTH( FROM_UNIXTIME(`stats_time`) ), YEAR( FROM_UNIXTIME(`stats_time`) )

Thanks very much in advance

2

what’s wrong with it?