Daily emailing of html page attatchment using PERL

Anyone done this before?

[wruk999]

Hi,
I have this task, and need some help if possible. I have not attempted Perl before, so I am being thrown in at the deepend a bit!

I need a script which will run on cron, with an offset of 8 hours, that will query a list of users in a MySQL dbase. It checks a column of the users table, which is an integer value, 0 or 1.
If set to 1, it will run a query on another table (stock table) and then email a html attatchment of the results to all the email addresses from the users table that had a value of 1 in the 'receive_email' column.

The server is Unix/Apache
Database is MySQL
Net::Smtp is installed.

Looking forward to hearing your suggestions.
Thank You.
wruk999

[jeremy goodrich]

Sounds like you have the steps down to develop the script. Now grab a copy of 'learning perl' or 'programming perl' and something on cron jobs on a *nix box & you are all set.

Just post when you get stuff, if you do. It sounds like a fairly simple thing to put together.