//query per maxtemp
$sqltmax="select max(`TEMP`)as maxtemp from `METEO` where date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$data."', '%d-%m-%Y')";

	$result = mysql_query($sqltmax);
		if (mysql_result($result, 0, "maxtemp") == 0) {
  			$maxtemp="0";
			} else {
  			$maxtemp=mysql_result($result, 0, "maxtemp");
		}
//query per ricavare l'orario del maxtemp
$sql = "SELECT `TIMESTAMP_LOCAL` from `METEO` WHERE `TEMP` = ".$maxtemp." and date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$data."', '%d-%m-%Y')";
$result = mysql_query($sql);
	if (mysql_num_rows($result) == 0 ) {
  		$maxtempt="00:00";
	} else {
  		list($expate, $exptime) = explode(' ', mysql_result($result, 0, "TIMESTAMP_LOCAL"));
		$maxtempt=$exptime;
	}

//query per mintemp
$sqltmin="select min(`TEMP`)as maxtemp from `METEO` where date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$data."', '%d-%m-%Y')";
	$result = mysql_query($sqltmin);
	if (mysql_result($result, 0, "maxtemp") == 0) {
  		$mintemp="0";
		} else {
  		$mintemp=mysql_result($result, 0, "maxtemp"); 
	}
//query per ricavare l'orario del mintemp
$sql = "SELECT `TIMESTAMP_LOCAL` from `METEO` WHERE `TEMP` = ".$mintemp." and date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$data."', '%d-%m-%Y')";
		$result = mysql_query($sql) ; 
	if (mysql_num_rows($result) == 0) {
  		$mintempt="00:00";
		} else {
 			list($expate, $exptime) = explode(' ', mysql_result($result, 0, "TIMESTAMP_LOCAL"));
			$mintempt=$exptime;
	}



$datay = strtotime($data);
$datay = strtotime("-1 day", $datay);
$datay = date('d-m-Y', $datay);

$sqltmax="select max(`TEMP`)as maxtemp from `METEO` where date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$datay."', '%d-%m-%Y')";

	$result = mysql_query($sqltmax);
		if (mysql_result($result, 0, "maxtemp") == 0) {
  			$maxtempyest="0";
			} else {
  			$maxtempyest=mysql_result($result, 0, "maxtemp");
		}
//query per ricavare l'orario del maxtemp
$sql = "SELECT `TIMESTAMP_LOCAL` from `METEO` WHERE `TEMP` = ".$maxtempyest." and date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$datay."', '%d-%m-%Y')";

$result = mysql_query($sql);
	if (mysql_num_rows($result) == 0 ) {
  		$maxtempyestt="00:00";
	} else {
  		list($expate, $exptime) = explode(' ', mysql_result($result, 0, "TIMESTAMP_LOCAL"));
		$maxtempyestt=$exptime;
	}

//query per mintemp
$sqltmin="select min(`TEMP`)as maxtemp from `METEO` where date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$datay."', '%d-%m-%Y')";
	$result = mysql_query($sqltmin);
	if (mysql_result($result, 0, "maxtemp") == 0) {
  		$mintempyest="0";
		} else {
  		$mintempyest=mysql_result($result, 0, "maxtemp"); 
	}
//query per ricavare l'orario del mintemp
$sql = "SELECT `TIMESTAMP_LOCAL` from `METEO` WHERE `TEMP` = ".$mintempyest." and date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$datay."', '%d-%m-%Y')";
		$result = mysql_query($sql) ; 
	if (mysql_num_rows($result) == 0) {
  		$mintempyestt="00:00";
		} else {
 			list($expate, $exptime) = explode(' ', mysql_result($result, 0, "TIMESTAMP_LOCAL"));
			$mintempyestt=$exptime;
	}
////query per maxwind
$sqlwind= "SELECT `WIND_AVE`,`WIND_CHILL`,`WIND_DAY_MIN`,`WIND_DAY_MAX`,`WIND_DAY_GUST_MIN`,`WIND_DAY_GUST_MAX` FROM `METEO` where date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$data."', '%d-%m-%Y') order by `TIMESTAMP_LOCAL` desc";
$result = mysql_query($sqlwind);
if (!mysql_num_rows($result) == 0) {
	$WIND_CHILL= round(mysql_result($result, 0, "WIND_CHILL"),0);
	$WIND_DAY_MIN= round(mysql_result($result, 0, "WIND_DAY_MIN"),0);
	$WIND_DAY_MAX= round(mysql_result($result, 0, "WIND_DAY_MAX"),0);
	$WIND_DAY_GUST_MAX= round(mysql_result($result, 0, "WIND_DAY_GUST_MAX"),0);
}


//Rain


$sql = "SELECT `RAIN` FROM `METEO` WHERE date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$data."', '%d-%m-%Y') ORDER BY `METEO`.`TIMESTAMP_LOCAL` DESC LIMIT 1";
	$result = mysql_query($sql) ; 
	if (mysql_num_rows($result) == 0) {
  		$rain1="0";
		} else {
 			$rain1= mysql_result($result, 0, "RAIN");
	}
	


$sql = "SELECT `RAIN` FROM `METEO` WHERE date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$data."', '%d-%m-%Y') ORDER BY `METEO`.`TIMESTAMP_LOCAL` ASC LIMIT 1";
$result = mysql_query($sql) ; 
	if (mysql_num_rows($result) == 0) {
  		$rain2="0";
		} else {
 			$rain2= mysql_result($result, 0, "RAIN");
	}
	

$dayrn =round($rain1-$rain2);//Pioggia odierna


$sql = "SELECT `RAIN` FROM `METEO` WHERE date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$datay."', '%d-%m-%Y') ORDER BY `METEO`.`TIMESTAMP_LOCAL` DESC LIMIT 1";
$result = mysql_query($sql) ; 
	if (mysql_num_rows($result) == 0) {
  		$rainy1="0";
		} else {
 			$rainy1= mysql_result($result, 0, "RAIN");
	}


$sql = "SELECT `RAIN` FROM `METEO` WHERE date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$datay."', '%d-%m-%Y') ORDER BY `METEO`.`TIMESTAMP_LOCAL` ASC LIMIT 1";
$result = mysql_query($sql) ; 
	if (mysql_num_rows($result) == 0) {
  		$rainy2="0";
		} else {
 			$rainy2= mysql_result($result, 0, "RAIN");
	}
	

	
$yesterdayrain=round($rainy1-$rainy2);




$datam = strtotime($data);
$datam = strtotime("-1 month", $datam);
$datam = date('d-m-Y', $datam);

$sql = "SELECT `RAIN` FROM `METEO` WHERE date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$datam."', '%d-%m-%Y') ORDER BY `METEO`.`TIMESTAMP_LOCAL` DESC LIMIT 1";

		$result = mysql_query($sql) ; 
	if (mysql_num_rows($result) == 0) {
  		$rainm="0";
		} else {
 			$rainm= mysql_result($result, 0, "RAIN");
	}
	
	$monthrn=round($rain1-$rainm);



$date1h=date("d-m-Y H:i:s", strtotime("-1 hours", time()));	

$sql = "SELECT `RAIN` FROM `METEO` WHERE date( `TIMESTAMP_LOCAL` ) = STR_TO_DATE('".$date1h."', '%d-%m-%Y') ORDER BY `METEO`.`TIMESTAMP_LOCAL` DESC LIMIT 1";

		$result = mysql_query($sql) ; 
	if (mysql_num_rows($result) == 0) {
  		$rainh="0";
		} else {
 			$rainh= mysql_result($result, 0, "RAIN");
	}

	$currentrainratehr=round($rain1-$rainh);
	
	
$yearrn	=round($rain1);


mysql_close($con);