tedd wrote:
At 1:26 PM +0200 5/27/08, Stefano Esposito wrote:
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 :)
Depending on how busy your website is, you might not need to alter you schema at all. ie Add a query to one page of your website that only runs when it's minute 1 of any (or a particular) hour. Depending on how busy your website is it may mean that the query runs too much or too little.
--
Richard Heyes
In Cambridge? Employ me
http://www.phpguru.org/cv
+----------------------------------------+
| Access SSH with a Windows mapped drive |
| http://www.phpguru.org/sftpdrive |
+----------------------------------------+