sorting results into month array

[chadedge]

Here's the issue:

query 1 would pull a list of events from a table based on the current date (all events w/ a date at least today or greater). I then need to take this result set and display to the user in groups of months, for instance:

1. select * from tblname (all my joins here) where eventdate >='$today' sort by eventdate asc

2. display to user as follows:

APRIL
.. event here
.. another event here

MAY
... event here
... more events here

and so on until the end of the last event list is shown (which could be two months future, or four, or six)...

So I guess what I need to know is 1) the list of events total to display; 2) the event furthest in the future (the last month to display; 3) the most current (soonest) event (to get the first month to display); 4) how in the hell to display a month-by-month sort of the events from the initial query.

Any ideas?

[devinemke]

tweak as necessary for your exact data structure:

$result = mysql_query('SELECT MONTH(eventdate) AS month, eventname FROM tablename WHERE eventdate >= CURDATE() ORDER BY eventdate');

while ($row = mysql_fetch_assoc($result))
{
	$array[$row['month']][] = $row['eventname'];
}

foreach ($array as $key => $value)
{
	echo '<b>' . $key . '</b><br>';
	foreach ($value as $eventname)
	{
		echo $eventname . '<br>';
	}
	echo '<br>';
}

[hatmaster]

Oops, I posted in the wrong place... :rolleyes: