<?php require_once("support/funformat.php");

echo "<script type=\"text/javascript\" src=\"support/tennisJS.js\"></script>";

?>



<?php



        $oldmm=-1; $flag =0; $conta = 0; $cm=0; // CONTATORE dei Men�

		$dbhost1 = "62.149.150.87"; $dbname1 = "Sql232590_2"; $dbuser1 = "Sql232590"; $dbpass1 = "ea37e15d";

		$conn1 = mysql_connect($dbhost1,$dbuser1,$dbpass1)

		or die("Impossibile collegarsi al server MySQL.");

		mysql_select_db($dbname1,$conn1)

		or die("Impossibile selezionare il database $dbname");



		$sql1 = "SELECT tennis.dapa, tennis.play1, tennis.play2, tennis.risu, tennis.super FROM tennis ORDER BY tennis.dapa DESC";



		$result1 = mysql_query($sql1,$conn1);

		if($result1){

					$i=0;

					do{

						$riga1=mysql_fetch_array($result1);

						$recordsetx[$i]=$riga1;

						$dd= $recordsetx[$i]['dapa'] ;

						$mm = substr($dd,5,2);	// Individua il Mese

						$aa = substr($dd,0,4);	// Individua l'Anno

						$flag=1;

						if ($mm != $oldmm){

							$flag=0;

						}

						if ($flag == 0){

								// NUOVO MENU'

							if ($conta!=0) {echo "</ul></li>";}

			if ($recordsetx[$i]['play1']!=""){

								$oldmm = $mm;

								$cm++;   // Contatore dei Men� Creati      class=\"menu1\"

							echo "<li style=\"margin-left:40px; background: url(images/ball.png) no-repeat 3px 5px; color:red;\" >";

								$m = MeDes($mm);

							echo "<a href=\"javascript:mmenu('submenu-$cm')\" style=\"text-decoration:none\">$m&nbsp;$aa</a>";

							echo "<ul style=\"line-style:none;margin-left:5px;\" class=\"submenu\" id=\"submenu-$cm\">";



							echo "<li style=\"background: url(images/tennis.png) no-repeat 10px 7px;\"><span style=\"margin-left:5px;padding-left:10px;font-size: small;color: #666666;\">";

								echo "(" .substr($dd,8,2) ."-" .f0($mm,2) ."-$aa)&nbsp;&nbsp;";

							echo $recordsetx[$i]['play1'] ."&nbsp;vs&nbsp;" .$recordsetx[$i]['play2'] ."&nbsp;&nbsp;" .$recordsetx[$i]['risu'] ."</span>";

							 echo "<span span style=\"margin-left:5px;padding-left:10px;font-size: small;color: #666666;\">";

							 echo "&nbsp;&nbsp;[" .$recordsetx[$i]['super'] ."]";

							 echo "</span></li>";

								$conta=1;

			}

						}else{

								// CONTINUA MENU' PRECEDENTE

							echo "<li style=\"background: url(images/tennis.png) no-repeat 10px 7px;\"><span style=\"margin-left:5px;padding-left:10px;font-size: small;color: #666666;\">";

								echo "(" .substr($dd,8,2) ."-" .f0($mm,2) ."-$aa)&nbsp;&nbsp;";

							echo $recordsetx[$i]['play1'] ."&nbsp;vs&nbsp;" .$recordsetx[$i]['play2'] ."&nbsp;&nbsp;" .$recordsetx[$i]['risu'] ."</span>";

							 echo "<span style=\"margin-left:5px;padding-left:10px;font-size: small;color: #666666;\">";

							 echo "&nbsp;&nbsp;[" .$recordsetx[$i]['super'] ."]";

							 echo "</span></li>";

						}

							$i++;

					}while($riga1);

						unset ($recordsetx[$i-1]);

				}else{

					return FALSE;

					mysql_close($conn1);

				}

                //vmPopupLinkPic("images/mie/tt.jpg",100,100,100) ;

?>

</html>