<?php
mysql_connect("localhost","root","") or die("connection faild");
mysql_select_db("con") or die ("database not avi");
$sql = "DELETE FROM `data` WHERE `date` <= CURDATE()";
$result = mysql_query($sql) or die("Error connecting to database!");
?>
<!DOCTYPE html>
<html>
<body>
<?php
date_default_timezone_set("America/New_York");
echo "The time is " . date("h:i:sa");
?>
</body>
</html>
mysql_connect("localhost","root","") or die("connection faild");
mysql_select_db("con") or die ("database not avi");
$sql = "DELETE FROM `data` WHERE `date` <= CURDATE()";
$result = mysql_query($sql) or die("Error connecting to database!");
?>
<!DOCTYPE html>
<html>
<body>
<?php
date_default_timezone_set("America/New_York");
echo "The time is " . date("h:i:sa");
?>
</body>
</html>
No comments