= (NOW() - INTERVAL $hours HOUR) order by dateandtime desc"; //NOTE: If you want to show all entries from current date in web page uncomment line below by removing // //$sql="select * from temperaturedata where date(dateandtime) = curdate();"; // set query to variable $temperatures = mysqli_query($connectdb,$sql); // create content to web page ?> Environment - 4thDnet
Temperatures


"; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
Date Sensor Temperature Humidity
".$temperature['dateandtime']."".$temperature['sensor']."".$temperature['temperature']."".$temperature['humidity']."