SELECT thedate, SUM(mydata) AS totalrainfall FROM rainfalldata GROUP BY thedate


SELECT DISTINCT thedate, MIN(totalrainfall),MONTH(thedate),DAY(thedate) FROM (SELECT DAY(thedate), sensor, SUM(mydata) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate), sensor) AS totalrainfall ORDER BY DAY(thedate)

Daily totals:-

SELECT DISTINCT DAY(thedate), SUM(mydata) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate)



SELECT DISTINCT MAX(totalrainfall) DAY(thedate), SUM(mydata) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate)



SELECT DISTINCT MAX(totalrainfall), Day(thedate), MONTH(thedate) FROM DAY(thedate), SUM(mydata) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate)

sorted wetest days
SELECT DISTINCT SUM(mydata), DAY(thedate), MONTH(thedate) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate) ORDER BY SUM(mydata) DESC 


SELECT emp_name, salary  FROM emp1  WHERE salary = (  SELECT MAX(salary) salary    FROM emp1 )

SELECT mydata, Thedate, sensor FROM `rainfalldata` WHERE mydate = (select MAX(mydate) mydata FROM rainfalldata)



SELECT MAX(totalrainfall), (SELECT DISTINCT SUM(mydata), DAY(thedate), MONTH(thedate) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate) ORDER BY SUM(mydata) DESC) From rainfalldata



SELECT * FROM (SELECT DISTINCT SUM(mydata), DAY(thedate), MONTH(thedate) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate) ORDER BY SUM(mydata) DESC) HAVING totalrainfall=MAX (totalrainfall)


Select MAX(totalrainfall) (SELECT DISTINCT DAY(thedate), SUM(mydata) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate) AS Dailytotals


SELECT SUM(mydata) (DISTINCT DAY(thedate),MONTH(thedate) AS totalrainfall FROM rainfalldata GROUP BY DAY(thedate) ORDER BY SUM(mydata) DESC


SELECT mydata, thedate, sensor FROM `rainfalldata` WHERE mydata = (select MAX(mydata) mydata FROM rainfalldata)

SELECT DISTINCT mydata, DAY(thedate), MONTHNAME(thedate), HOUR(thedate), MINUTE(thedate), sensor FROM `rainfalldata` WHERE mydata = (select MAX(mydata) mydata FROM rainfalldata)



" .$r["MINUTE(thedate)"]""


echo " recorderd a maximum reading of " . $r["mydata"]."mm <br> On the ".$r["DAY(thedate)"]."-".$r["MONTHNAME(thedate)"]." at ". $r["HOUR(thedate)"]. ":" . $r["MINUTE(thedate)"]."<br><br>"


$query="SELECT DISTINCT mydata, DAY(thedate), MONTHNAME(thedate), HOUR(thedate), MINUTE(thedate), sensor FROM `rainfalldata` WHERE mydata = (select MAX(mydata) mydata FROM rainfalldata)";

$query="SELECT * FROM rainfalldata WHERE sensor like '$search%'";



SELECT DISTINCT id, mydata, DAY(thedate), MONTHNAME(thedate), HOUR(thedate), MINUTE(thedate), sensor FROM rainfalldata Where sensor like '1'


echo $r["DAY(thedate)"]."-".$r["MONTHNAME(thedate)"]." at ". $r["HOUR(thedate)"]. ":" . $r["MINUTE(thedate)"]."</td><td>";


$query="SELECT DISTINCT id, mydata, DAY(thedate), MONTHNAME(thedate), HOUR(thedate), MINUTE(thedate), sensor FROM rainfalldata Where sensor like '$search%' ORDER BY thedate DESC"



SELECT DISTINCT id, mydata, DAY(thedate), MONTHNAME(thedate), HOUR(thedate), MINUTE(thedate), sensor FROM rainfalldata Where like '$search%' ORDER BY thedate DESC

2019-12-14

$query="SELECT DISTINCT id, mydata, DAY(thedate), MONTHNAME(thedate), HOUR(thedate), MINUTE(thedate), sensor  WHERE thedate like '$search%' ORDER BY thedate DESC"



echo "<tr><td>";    
					echo $r["id"]." </td><td> ";
					echo $r["mydata"]."</td><td>  ";
					echo $r["DAY(thedate)"]."-".$r["MONTHNAME(thedate)"]." at ". $r["HOUR(thedate)"]. ":" . $r["MINUTE(thedate)"]."</td><td>";
					//echo $r["thedate"]."</td><td>  ";
					echo $r["sensor"]."</td></tr>";


$cfg ['width'] = 1000;		//number of pixels horizontally
     $cfg ['height'] = 700;		//number of pixels vertically
     $cfg ['title'] = 'Combined reading of all sensors';
     $cfg ['title-visible'] ='true';
     $cfg ['title-font-size'] = '6';
     $cfg ['title-color'] = '#FFFFFF';
     //$cfg ['background-color'] = 'rgba (0,0,0,0)';
     $cfg ['zero-line-color'] = '#ffffff';
     $cfg ['background-color'] = '#5f9ea0';
     $cfg ['average-line-color'] = '#FFFFFF';
     $cfg ['box-border-visible'] = 'false';
     $cfg ['border-box-visable'] = 'false';
     $cfg ['column-divider-visible'] = 'false';
     $cfg ['value-visible'] ="true";
     $cfg ['label'] ='Rainfall in mm';
     $cfg ['label-color'] = '#FFFFFF';
     $cfg ['label-font-size'] ='1';
     $cfg ['label-visable'] = 'true';
     $cfg ['value-visible'] = 'true';
     $cfg ['value-label-visible'] = 'true';
     $cfg ['value-label-color'] ='#FFFFFF';
     $cfg ['box-background-visible'] ='false';
     $cfg ['horizontal-divider-visible'] ='false';
     $cfg ['average-line-visible'] = 'false';
     $cfg ['key-visible'] = 'true';