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[3]);
		$unix_time_end   = strtotime($entry[4]);
	
		// 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();
		}
		
		// DAYS
		if (!in_array($entry[5],$days)){
		
			echo '<li>';
			echo '<div class="date">';
				echo date('j',$unix_time_start) . '-' . date('j',$unix_time_end) . ':';
			echo '</div>';
			
						
			if (strlen($entry[1]) >= 60){
				$title = substr($entry[1],0,60) . '...';
			}
			else{
				$title = $entry[1];
			}
		
			
			echo '<div style="float: left;">';
				echo '<a href="http://www.fhsu.edu/calendar/?view=details&amp;id=' . $entry[0] . '">' . $title . '</a>';
			echo '</div>';
				echo '<div style="clear: both;"></div>';
				
			$days[] = $entry[5];
		}
		else{
			echo date('j',$unix_time_start) . '-' . date('j',$unix_time_end) . ':';
			
			$days[] = $entry[5];
		}

		
		$first = false;
		$first_day = false;
	}
echo '</ul></li></ul></li></ul>';
?>