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)."'");
You could have it triggered manually, or by your website say. Or you
could (if you have it) use a cron job on another machine. You must of
course be able to connect to MySQL remotely from this box if you choose
that route. Depending on your MySQL version triggers may be able to do
it too - but I've not used these so I couldn't say for sure.
--
Richard Heyes
In Cambridge? Employ me
http://www.phpguru.org/cv
+----------------------------------------+
| Access SSH with a Windows mapped drive |
| http://www.phpguru.org/sftpdrive |
+----------------------------------------+
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
