I handle your object a different and, I believe, a simpler way.

Instead of a cronjob, I call a cleanup function whenever a page is opened.

Obviously, this approach requires a time overhead and thus is not good for very high volume sites. You can mitigate this drawback by maintaining a simple touch() file that keeps track of the time when your cleanup function is run and insure it only runs once a day, or whatever frequency you need. You can even make the file sticky so it stays in memory to further reduce the overhead.



Steven Macintyre wrote:
 Hi,

I need to be able to do the following procedure;

retrieve all items from a mysql db table, then check to see if the files from that table 
exist on the server (images), if not, to "clean up" and remove the physical 
file - so that only the files from the db exist.

This will run via cron

Has anyone done something similar before, willing to assist me with a basic 
scope of actions to work on?

Thanks in advance

Steven


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

Reply via email to