in reply to Perl/mySQL question
If you are using MySQL now but something later this may not be such a good suggestion but I am sure there will be an equivalent command. If the internal database is the database that will be the most up-to-date and the one on the Web is the one that you need to keep updated rthen why don't you just do a mysqldump and then a mysqlimport. We use ti a lot here and it is a simple one step in Perl. In other words, let mySQL do its job and just have Perl to remind it to do so?