Hello list,
If you let me, I'd modify the code to use TRUNCATE instead of DELETE when emptying tables if MySQL 4 is used since this is a much faster way: The DELETE command deletes the table content row by row while TRUNCATE drops and recreates the table. Some doc about this: http://www.mysql.com/doc/T/R/TRUNCATE.html
Alexander