query=
SELECT DateTime, avg(T), avg(A), min(Tmin), max(Tmax), avg(D)
FROM alldata
WHERE DATE(alldata.DateTime) = CURDATE()
GROUP BY YEAR(alldata.DateTime), MONTH(alldata.DateTime), DAY(alldata.DateTime), HOUR(alldata.DateTime), MINUTE(alldata.DateTime)
ORDER BY DateTime
error=
n.rows=
result=
Array
(
[name1] => Temperature
[name2] => Apparent temperature
[name3] => Range
[name4] => Dew point
)
{"name1":"Temperature","name2":"Apparent temperature","name3":"Range","name4":"Dew point"}