a grouping question?

d34db0lts

now i'm not sure if this belongs in a mysql section but something tells me it's more of a php question.

so the is the deal:
i have this part in my website that will show shows (concerts) in order of the months by date.

so like all january would be shown in one group and then all february shows would be shown as well...in this fashion:

January:
show1
show2
show3

February:
show4
show5
show6

the problem is that i dont know how to retrieve the data in this format. what i wanted to do is do a while function that loops the months (Jan, Feb) and then inside that loop put another while function that loops all the shows in that month. since this is the first time i do this, i'm basically asking if there's other ways to do this more efficiently. something tells me that there has to be an easier way.

if anybody can help that'd be great. thanks for any insights.

clogfan

You don't specify where your data is. If your data is in a database, like mysql, you can retrieve your data in the right order if you want. In your query (SELECT * FROM concerts WHERE 1 ORDER BY date), you can tell that you want the result ordered (by default ascending) by date. Then you only need a single loop where you check for month changes.

Good luck !

d34db0lts

clogfan

You can do this with a single query.

You can do the split logic in your loop of the result :

Here is the pseudocode :