{body}


{literal}

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="accordion.js"></script>

<style>
#wrap table {
  width: 600px;
  text-align: center;
  border-collapse: collapse;
}
#wrap table td {
  border: 1px solid black;
}
#wrap table tr.head {
  background: url("/img/bgtop3.jpg") no-repeat scroll left top transparent;
  font-weight: bold;
}

#wrap div.block
{
	padding: 10px; margin: 0;
	font-size: 13px; font-family: Tahoma; font-weight: normal;;
		
	border: 1px solid #ccc;
	border-radius: 3px;
	-o-border-radius: 3px;
	-moz-border-radius: 3px;
	-webkit-border-radius: 3px;	
}

#accordion h3
{ 
	margin: 1px 0; padding: 5px 10px;
	font-size: 17px; font-family: Tahoma; font-weight: normal; color: #fff;
	background: #4073A6; 
	cursor: pointer;
					
	border-radius: 3px;
	-o-border-radius: 3px;
	-moz-border-radius: 3px;
	-webkit-border-radius: 3px;
										
	text-shadow: 1px 1px 0px #000;
	-o-text-shadow: 1px 1px 0px #000;
	-moz-text-shadow: 1px 1px 0px #000;
	-webkit-text-shadow: 1px 1px 0px #000;
}  
</style>
{/literal}

<div id="wrap">
<div id="accordion">

{php}
function printAwards($olympStatus = -1) {

    connectMySQL();
    mysql_select_db("school");

    $query = "select * from awards";
    if ($olympStatus != -1) {
    	$query .= " where olympStatus=$olympStatus";
    }
    $query .= " order by year desc, olymp, name";
    $res = mysql_query($query);

    while ($row = mysql_fetch_assoc($res)) {
   	$data[$row["year"]][] = $row;
    }    

    foreach ($data as $year => $yearData) {
    	echo "<h3>" . ($year-1) . "&mdash;" . "$year год</h3>";
	echo "<div class='block'><table>";

	$olymp = "";
	foreach ($yearData as $award) {
		if (strcmp($award["olymp"], $olymp) != 0) {
			$olymp = $award["olymp"];
			echo "<tr class='head'>";
			echo "<td colspan=3>$olymp</td></tr>";
		}
		echo "<tr><td>" . $award["name"] . "</td><td>" . $award["class"] . "</td><td>" . $award["award"] . "</td></tr>";
	}
	echo "</table></div>";
    }
}

$olympStatus = $_GET["s"];
if ($olympStatus === NULL) {
	$olympStatus = -1;
}
printAwards($olympStatus);
{/php}

</div>
</div>

{/body}