Can I do a automatic record delete? For example, I would have the possibility to select a "option" that delete record in certain date, in automatic mode.

it is possible? (excuse me for my english..eheh:))

thanks

joeore

I don't really know what you mean. Can you be more descriptive? I don't know what you mean by "automatic mode".


Take care,

Nik
http://www.bigaction.org/

hello nikolai:), I mean that a record must be deleted when pass a certain time, for example 15 days.

It's possible?

joeore:)

You can't write anything into the record that effectively gives it a "time to live", but depending on how much access you have to the machine you are running on, you could use something like a cron job (aka. a "Scheduled task" on Windows) or a stored procedure running on the database itself (assuming you database manager supports them - recent versions of MySQL, Postgres and SQL Server do, Access doesn't).

Run it at midnight each day to filter off records you no longer want.

Right. Your PHP script would look something like this:

<?php // delete_old.php

// connect to db here...

$expired = date("Y-m-d", strtotime("-15 days"));

$query = "DELETE FROM table WHERE date_col < '$expired'";
mysql_query($query);
?>

On the commandline, you would execute this by:

php -q delete_old.php


strtotime() creates a UNIX timestamp based on a string representation. We create the timestamp for 15 days ago. We use date() to format it into YYYY-MM-DD format, which is how MySQL stores items in DATE columns. (DATE is a MySQL data type).

More info:
  http://www.php.net/strtotime
  http://www.php.net/date


Take care,

Nik
http://www.bigaction.org/

Or (swiftly dons smart-arse cap, at this point):

date("Y-m-d", strtotime("fortnight 1 day ago"));

A swift guide to the GNU fuzzy-logic relative time functions can be found here.
http://www.gnu.org/software/coreutil...27.html#SEC174

Dan