Timing databases, then renew

[spighita]

Hello:
I need to create a database where the database expires on Friday, get exported to an excel sheet and then renew the database. The idea is people signing through the week and then printed on Friday. Then again and so on.

Thanks in advance for anyone who helps. I use MYSQL & PHP

[barand]

Probably easier to have records expiring than the database.

Include a timestamp field to record when the records are added

Each week on Friday

select * from mytable where timefield between '$mondate' and '$fridate'

write these records to a csv file or tab delim file

Optionally (though not necessary) when you are sure you have the data :-

delete from mytable where timefield between '$mondate' and '$fridate'

hth