| ";
echo $row['datum'];
$datum=$row['datum'];
$SQL="select
round (min(temp_aussenmin),1) as min,
round(max(temp_aussenmax),1) as max,
round(avg(temp_aussenavg),1)as avg,
round(sum(rainsum),1) as rain,
count(IF (rainsum > 0,1,NULL)) as regentage,
count(IF (temp_aussenmin<0,1,NULL))as frosttage,
count(IF (temp_aussenmax<0,1,NULL))as eistage,
count(IF (temp_aussenmax<10,1,NULL))as kaltetage,
count(IF (temp_aussenmax>18,1,NULL))as warmetage,
count(IF (temp_aussenmax>25,1,NULL))as sommertage,
count(IF (temp_aussenmin>20,1,NULL))as tropentage
from tagij
where date_format(datum, '%m.%Y')=$datum;";
$ret = mysqli_query($db, $SQL );
$row1 = mysqli_fetch_array($ret, MYSQLI_ASSOC);
echo " | ";
echo $row1['min']; echo " °C";
echo " | ";
echo $row1['max']; echo " °C";
echo " | ";
echo $row1['avg']; echo " °C";
echo " | ";
echo $row1['eistage']; echo " ";
echo " | ";
echo $row1['frosttage']; echo " ";
echo " | ";
echo $row1['kaltetage']; echo " ";
echo " | ";
echo $row1['warmetage']; echo " ";
echo " | ";
echo $row1['sommertage']; echo " ";
echo " | ";
echo $row1['tropentage']; echo " ";
echo " | ";
echo $row1['rain']; echo " mm";
echo " | ";
echo $row1['regentage']; echo " ";
echo " |