X-Git-Url: https://git.rvb.name/weathermon.git/blobdiff_plain/3a48d89e76fd2ab87dabf08632474c529cf77ad4..49789b14a3818948a0f10e40108545965b8e1a81:/web/index.php diff --git a/web/index.php b/web/index.php index d513251..dfc7450 100644 --- a/web/index.php +++ b/web/index.php @@ -2,9 +2,14 @@ - + WeatherMon (Последние 24 часа) + prepare( where v.timestamp>adddate(now(), -1) and v.sensor_id=s.id - and s.st_id=p.st_id' + and s.st_id=p.st_id + and p.id>=0 + order by s_description,st_description' ); $q -> execute();