Code : Tout sélectionner

$query = "SELECT AVG(MaxTemp), AVG(MinTemp) FROM dayfile WHERE DATE_FORMAT(LogDate, '%d')= ".$day." and DATE_FORMAT(LogDate, '%m')= ".$month;

$result = mysql_query($query);
if (!$result) {
	die("ERROR - Bad Select Statement");
}

while($row = mysql_fetch_row($result)) {
	$maxRec = (float)$row[0];
	$minRec = (float)$row[1];
}

$query = "SELECT DATE_FORMAT(LogDate,'%Y'),maxtemp, mintemp, avgtemp FROM dayfile WHERE DATE_FORMAT(LogDate, '%d')= ".$day." and DATE_FORMAT(LogDate, '%m')= ".$month." ORDER BY DATE_FORMAT(LogDate,'%y')";
//print_r ($query);
$result = mysql_query($query);
if (!$result) { printf ("ERROR - Bad Select Statement"); exit; }

// import the rows and put the data into arrays
while($row = mysql_fetch_row($result)) {
	$title[] = $row[0];
	$valMax[] = (float)$row[1];
	$valMin[] = (float)$row[2];
	$valAvg[] = (float)$row[3];
	//$valAvg[] = array((float)$row[3]-0.1,(float)$row[3]+0.1);
	$valTemp[] = array((float)$row[2], (float)$row[1]);
}

// put into a single array
$ret = array($title, $valMax,$valMin,$valAvg,$valTemp,$maxRec,$minRec);