temporary storage

[Lambneck]

Is there a way to put a time limit on how long information is stored in a database?

 

For example:

User submits form data to database. It is stored there for 30 days,

then after that 30 days is automatically deleted from database table.

 

[JasonLewis]

You would need to use a Cron Job that would run daily to check for information that is 30 days or older, then delete it from the database.

[vbnullchar]

you add an extra field in you db that contains the timestamp of the date it was submitted..

then setup a cron that deletes record if date is more than 30dys

[Lambneck]

Could it be done through the UPDATE statement?

 

ex.

<?php
UPDATE $tablename DELETE * WHERE $submission_date == "+30"
?>

...or something like that