delete after a priod

[asmith]

don't know if it is  php or sql question :

how can i delete a record in sql after a time prioad automaticlly ?

for example delete filed1 where id="1" , 5 days after it has been recorded.

?

[PHP_PhREEEk]

Add a timestamp field to the records. Record the time each record is created.

 

create a delete routine that checks if timestamp + offset < current timestamp

 

if true, delete

 

you can embed this as a function in any script that gets heavy use on the server, and it should be fairly regular about deletions. If you need precision, you'll need to save the delete routine to its own script and run it via CRON every n number of minutes, hours, or daily.

 

PhREEEk

[asmith]

what is a delete routine ?

sorry but can you please show me an example  ?( not too much code, just a simple one)

[PHP_PhREEEk]

<?php
$offset = '432000'; // 5 days
$now = time();
$sql = "DELETE FROM `tableName`
        WHERE `timeStamp` + $offset < $now
       ";
if ( !$result = mysql_query($sql) ) {
    // show errors
}
// all expired records (in this case, 5 days old) were removed

 

PhREEEk

[Foser]

would that work even if no one would go to the page?

[PHP_PhREEEk]

you can embed this as a function in any script that gets heavy use on the server, and it should be fairly regular about deletions. If you need precision, you'll need to save the delete routine to its own script and run it via CRON every n number of minutes, hours, or daily.

 

Not sure I understand the confusion Foser...

 

PhREEEk

[monkeybidz]

If you have a cron file on the side, you may want to add that code to cron file and include it to your index file which is the heaviest visited file and will execute the script. This will only be executed each time the page is visited.