krcoder

I am trying to format data pulled from the DB

I want to formatt the date with the current month first and the days in these months Grouped.

This piece of code is pulling the current month first correct
(1) SELECT * FROM newsroom ORDER BY MONTH(Post_date);


When I add the GROUP BY to sort days it breaks ??

(2)SELECT * FROM newsroom ORDER BY MONTH(Post_date) GROUP BY DAY(Post_date);


The results for the First (1) SQLstatment
** Note the date should be grouped to only show one of the months day

Printed results:

January 2005
07 13 20

October 2004
09 03

November 2004
10 11 10 12 15 26 29 30

December 2004
10 01 02 03 06 10 12 14 15