Sensor Data:"; echo "
"; echo "

Last Reading Data:

"; $servername = "gator3185.hostgator.com"; $username = "garneake_jws"; $password = "jws123"; $dbname = "garneake_lakedata"; // Create connection $con = mysqli_connect($servername, $username, $password, $dbname); if (mysqli_connect_errno()) { echo "Unable to connect to database."; echo "Error: " . mysqli_connect_error(); exit(); } //$sql = "SELECT * FROM SensorData LIMIT 1"; $sql = "SELECT * FROM SensorData ORDER BY DateTime DESC"; $result = mysqli_query($con, $sql,MYSQLI_STORE_RESULT); //echo("SELECT Status: " . mysqli_error($con) . "
"); if ($result = mysqli_query($con, $sql)) { // Fetch one and one row while ($row = mysqli_fetch_row($result)) { echo "Date: " . $row[0] . " "; echo "Height: " . $row[1] . " "; echo "Status: " . $row[2] . "
"; } mysqli_free_result($result); } ?>