Setting a time limit

[Anon]

Hi All

What I'm looking to do is have a user submit a order once the order is completed and the user hit the submit to end that order I want to put a time limit on how long that order remains in the db (MySQL) ie 30 days then delet form DB

Is this possible and if so how

TIA
Richie TM

[Anon]

Hi

What i would do is to run a cron script that goes through the database and deletes the records that belongs to the orders that are over 30 days old.

Like this:

SELECT * from orders WHERE TO_DAYS(NOW()) - TO_DAYS(Orderdate) > 30 AND Active ='Y';

Do loop here to delete the records.

Hope this helps

Tom

[Anon]

Richie,

just before u r using the insert query (for inserting the values of the form into the database), write a delete query and use a WHERE clause in which u can specify that (date_stored) <= (current_date - 30).

where..

1. date_stored is one of the fields of the table in which u r storing the submitted form (if u r not storing the date of submitting the data from the form u should do it)

2. current_date is , i think u can find out the current system date.

if above creates problem, let me know.

vishwa vivek