20 lines
443 B
PHP
20 lines
443 B
PHP
<?php
|
|
include("../dbinfo.php");
|
|
|
|
$con=mysqli_connect($host,$username,$password,$database);
|
|
$query = "SELECT TIMEDIFF ((SELECT date FROM plc GROUP BY totnorth ORDER BY id DESC LIMIT 1),(SELECT date FROM plc GROUP BY totnorth ORDER BY id DESC LIMIT 1, 1)) AS time";
|
|
$result=mysqli_query($con,$query);
|
|
|
|
$include2=mysqli_fetch_array($result,MYSQLI_ASSOC);
|
|
|
|
mysqli_close($con);
|
|
?>
|
|
|
|
<table>
|
|
<tr>
|
|
|
|
<?php echo $include2['time']; ?>
|
|
|
|
</tr>
|
|
</table>
|