Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Delete database data when date passes automatically

Delete database data when date passes automatically

Thread began 11/23/2010 1:49 pm by bill173836 | Last modified 11/29/2010 8:48 am by bill173836 | 3497 views | 7 replies

11/24/2010 10:58 ambill173836

Thanks, I figured it out.

<?php
$con = mysql_connect("localhost","databasename","databasepassword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("databasename", $con);
mysql_query("DELETE FROM TableName WHERE FieldName < NOW()");
mysql_close($con);
?>

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.