Expiring Table Entries?

Can make a table that some how entries will expire and do something or maybe just delete themselves after a certain perdiod of time or at a certain date?
Is there a data type for that?

thanks,
mike

Hi,

You can't set expiry date in the table.

You should write a program that should delete the values of a particular period.

eg: "DELETE FROM tablename WHERE TO_DAYS(NOW())-TO_DAYS($date_field)=60";


And above script should work frequently in your server.


Perhaps you may use "cron job" for performing
frequent action in the server...

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Mikeage:
Can make a table that some how entries will expire and do something or maybe just delete themselves after a certain perdiod of time or at a certain date?
Is there a data type for that?

thanks,
mike[/quote]

Mike,

I saw this somewhere.
You need an entrydate int, and expiredate int, in your table and then sth like this included in a function ExpireThings()

$today = Date("Ymd");
$sql = "DELETE FROM things WHERE expiredate<$today";

Brian