Page 1 of 1

Format SQL to display data in a group?

Posted: Wed May 23, 2007 8:00 pm
by influenceuk
Can any one tell me if there is a way to display data from a MySQL DB in groups?

For example:

May:
Item 1 1/05/2007
Item 2 2/05/2007
Item 3 3/05/2007

June:
Item 4 1/06/2007
Item 5 2/06/2007
Item 6 3/06/2007

And so on...

Obviously i would be after having a title of that current month etc. But would need the data to go and update on its own, so once may has gone, June would be he first month, if you see what i mean?

Any help would be great cheers:D

Posted: Thu May 24, 2007 1:31 am
by mentor
Try ROLLUP.