Change month name to number --- June to 6

$start = '2010-01-01'; // start of data to look at
$end = '2010-12-30'; // end of data to look at
$query = "SELECT DISTINCT YEAR(ev_dat) as year, UPPER(MONTHNAME(ev_dat)) as month FROM diary WHERE ev_dat  ORDER BY ev_dat";
$result = mysql_query($query) or die("Query failed: $query<br />Mysql error: " . mysql_error());

$current_year = '';
while($row = mysql_fetch_assoc($result)){
        // test for a change in the year
	if($current_year != $row['year']){
		echo $row['year'] . '<br />';
		$current_year = $row['year']; // remember the new year
	}
	echo "<a href='?year={$row['year']}&month={$row['month']}'>{$row['month']}</a><br />"; // in case you wanted links
	//echo "{$row['month']}<br />";
}

Select allOpen in new window