Delete database data when date passes automatically

Is there a way for dataassist to delete inserted data in my database when A specific date passes. I have a database that uses a date field and I want it to automatically delete from the database when that date is passed.

You could try adding the delete multiple records to your home page for example then when anyone visited your home page any records prior to what ever date you put in your recordset would get deleted.

I haven't tried it but I don't see why it wouldn't work.

You can probably just add a recordset to the top of the page with a query like:

DELETE FROM Table WHERE DateField < NOW()

<?php DELETE FROM events WHERE Date < 'NOW()'; ?>

I tried this but all I'm getting is a parsing error. An suggestions?

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);
?>

or just use the DW recordset and enter that as the query in the advanced tab and you don't have to write any of the other code by hand.

I tried that but dreamweaver would let me save it. It kept saying that it needed something.

I see... yeah I guess you would have to create the recordset with:

SELECT * FROM TableName WHERE FieldName < NOW()

and then edit it in the code to the actual query you want after it is applied.