Periodically delete old records from mysql table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,

i'm wandering if there's some intelligent way to delete old records
from a mysql table without using cronjobs (i can't), using PHP.
This table has a field which stores the value returned from time(), and
i want to do 

mysql_query("DELETE FROM `table` WHERE `time`<='".(time()-86400)."'");

at periodical intervals (say every 15 hours). Thanks for any hint :)

Ciao,
Stefano
 
 
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f
 
 Sponsor:
 Vasco è tornato! Sul tuo cellulare Il mondo che vorrei
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7749&d=27-5

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux