Perl script to work with mysql database

I need a perl script which will check my mysql database for new work orders, search my ZenCart database (which is different from my mysql database, though they both use mysql) to get some required data, calculate a couple of things and output a separate text file for each work order containing mostly the same information but including the order-specific data pulled from the databases and the calculated pieces I mentioned. Really quite simple for someone who knows Perl, mysql and Zen Cart.