Group the month by year

curb

I have a database with birthday posts that's grouped by the month. How do I make a "category" for the year, then have the month as the subcategory?

What I have Now:
January 2006, February 2006,...January 2007,..May 2007

Example Output of what I'm trying to do:
2007
January >> February >> March etc

2006
January >> February >> March >> April

      $result = mysql_query("SELECT FROM_UNIXTIME( time, '/%M/%Y/' ) AS get_year, time FROM `birthday` GROUP BY get_year ORDER BY time DESC;");

  while ($row = mysql_fetch_array($result)) {
      $get_year = $row['get_year'];

      echo "<a href=\"index.php?date=$get_year\">$get_year</a>";
  }

deezerd

"SELECT YEAR(time_field) AS get_year, 
      MONTH(time_field) as get_month 
FROM `birthday` 
GROUP BY get_year, get_month 
ORDER BY time DESC;"

curb

How would I while loop it where the output would be something like this:

<h3>2007</h3>
<a href="">January</a>,
<a href="">February</a>,
<a href="">May</a>,
<a href="">August</a>

<br><br>

<h3>2006</h3>
<a href="">June,</a>,
<a href="">October</a>,
<a href=""> November</a>,
<a href="">December

Right now, the while loop outputting is like this:

2007 January, 2007 February, 2007 May, 2007 August, etc

deezerd

You just have to loop the results twice

curb

Is there a way to create one query loop?

I have another page that keeps track of all the kids birthdays.

2-3 kids would have the same date so I would like it to join under one date.

August 1
Jane

August 2
Adam
John

August 3
Mike
David

That means I would have to keep looping for each day.

curb

Any ideas?