Group By Month/Year Within Array

Group By Month/Year Within Array

El Forum
Unregistered

#10

03-16-2009, 09:17 AM

[eluser]xwero[/eluser]
I think a simple query will do in that case
[quote]SELECT meet_date FROM table WHERE open=1 AND meet_date > CUR_DATE() ORDER BY meet_date[/code]
When you loop the results you check the year and month for changes to make your groups on the page.

Messages In This Thread

Group By Month/Year Within Array - by El Forum - 03-13-2009, 03:06 PM

Group By Month/Year Within Array - by El Forum - 03-13-2009, 03:21 PM

Group By Month/Year Within Array - by El Forum - 03-13-2009, 04:22 PM

Group By Month/Year Within Array - by El Forum - 03-13-2009, 04:26 PM

Group By Month/Year Within Array - by El Forum - 03-13-2009, 04:33 PM

Group By Month/Year Within Array - by El Forum - 03-14-2009, 05:46 AM

Group By Month/Year Within Array - by El Forum - 03-14-2009, 06:29 AM

Group By Month/Year Within Array - by El Forum - 03-14-2009, 07:13 AM

Group By Month/Year Within Array - by El Forum - 03-16-2009, 08:42 AM

Group By Month/Year Within Array - by El Forum - 03-16-2009, 09:17 AM

Group By Month/Year Within Array - by El Forum - 03-16-2009, 11:48 AM

Group By Month/Year Within Array - by El Forum - 03-16-2009, 12:14 PM

Group By Month/Year Within Array - by El Forum - 03-16-2009, 01:47 PM