Well, I'd say everything is ok but nothing works.
The sql query returns no error and no result.
Please try executing this sql query in phpmyadmin ( copy in the sql tab and click go ), it should return many rows:
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
If the above returns 0 rows try the followings:
SELECT DateTime, avg(T), avg(A), min(Tmin), max(Tmax), avg(D) FROM alldata WHERE DATE(alldata.DateTime) = CURDATE() ORDER BY DateTime
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 alldata.DateTime
SELECT DateTime, avg(T), avg(A), min(Tmin), max(Tmax), avg(D) FROM alldata WHERE DATE(DateTime) = CURDATE() GROUP BY YEAR(DateTime), MONTH(DateTime), DAY(DateTime), HOUR(DateTime), MINUTE(DateTime) ORDER BY DateTime
SELECT DateTime, T, A, Tmin, Tmax, 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
This should work ( as it the same query used by station data blocks that works in your homepage ):
SELECT max(Tmax), min(Tmin), avg(T), avg(H), max(H), min(H), avg(P), max(P), min(P), avg(A), max(A), min(A), avg(D), max(D), min(D), avg(W), max(W), avg(G), max(G), avg(S), max(S), max(R), min(W), min(G), min(S), max(RR) FROM alldata WHERE DATE(DateTime) = CURDATE()
Please also check that the structure of the alldata table is similar to this one:
[ You are not allowed to view attachments ]