[RESOLVED] Sorting dates

[sidsel]

I have a table looking like this:

mydate | rawhits | uniquehits

2005-09-04 | 15 | 12
2005-09-05 | 25 | 22
2005-10-14 | 18 | 16
2005-10-15 | 29 | 24
2005-11-22 | 42 | 39
2005-11-23 | 43 | 38

I have some trouble formatting my query right.
How do i sum up rawhits & uniquehits grouped by month?

Example:

September | 2005 | 40 | 34
October | 2005 | 47 | 40
November | 2005 | 85 | 77

[paulnaj]

This should do it (barring typos) ...

SELECT	DATE_FORMAT(`mydate`, '%M') AS `month`
,	DATE_FORMAT(`mydate`, '%Y') AS `year`
,	SUM(`rawhits`) AS `rawhits_count`
,	SUM(`uniquehits`) AS `uniquehits_count`
FROM mytable
GROUP BY DATE_FORMAT(`mydate`, '%Y-%m');

Paul 🙂

[sidsel]

Thanks....