Stuff

<?php

$sqlManager->selectDB('calendar');

$query = "SELECT events.id,
					events.name,
					activities.all_day,
					activities.start_date_time,
					activities.end_date_time,
					activities.event_id
					 FROM `events`,`authorized`,`activities` WHERE authorized.calendar_id = 21 AND events.id = authorized.event_id AND events.id = activities.event_id ORDER BY activities.start_date_time ASC";

$entries = $sqlManager->getResults($query);

// Archive Script of Death

$years = array();
$first = true;
$first_day = true;

echo '<ul class="calendar_archive">';
	foreach($entries as $entry){
		$unix_time_start = strtotime($entry['start_date_time']);
		$unix_time_end   = strtotime($entry['end_date_time']);
	
		// YEARS
		if (!in_array(date('Y', $unix_time_start), $years)){
			if(!$first){
				echo '</ul></li></ul></li>';
			}
			
			echo '<li><h2>' . date('Y', $unix_time_start) . '</h2><ul>';
			
			$years[] = date('Y', $unix_time_start);
			$months = array();
		}
		
		// MONTHS
		if(!in_array(date('F', $unix_time_start), $months)){
			if(count($months) > 0){
				echo '</ul></li>';
			}
			
			echo '<li><h3>' . date('F', $unix_time_start) . '</h3><ul>';
			
			$months[] = date('F', $unix_time_start);			
			$days = array();
		}
		
		if (strlen($entry['name']) >= 60){
			$title = substr($entry['name'],0,60) . '...';
		}
		else{
			$title = $entry['name'];
		}
		
		
		// DAYS
		if (!in_array($entry['event_id'],$days)){
			echo '<li>';
				echo '<div class="date">';
					if ($unix_time_start != $unix_time_end){
						echo date('j',$unix_time_start) . ':';
					}
					else{
						echo date('j',$unix_time_start) . '-' . date('j',$unix_time_end) . ':';
					}
				echo '</div>';
		
				echo '<div style="float: left;">';
					echo '<a href="http://www.fhsu.edu/calendar/?view=details&amp;id=' . $entry['event_id'] . '">' . $title . '</a>';
				echo '</div>';
				echo '<div style="clear: both;"></div>';
				
				$days[] = $entry['event_id'];
		}
						
		$first = false;
}
echo '</ul></li></ul></li></ul>';
?>