Hi crew: I want to delete material from a database if it is older than say one month since its insertion. However I don't want to have to run a cron-job or something, as there must exist a way for a script to execute itself periodically or to have the MySQL database tell *itself* to execute a specific SQL query periodically. I've heard it is possible to 'sink' a query into an Oracle DB itself instead of running something like a cron-job, so I'd like to hear from anyone who may have done this for MySQL or knows of an alternative method I can achieve my goal. Many thnaks to you all in advance. Russ #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #-------------------------------------------------------# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]