That code works nicely, thanks.
Users in my db can add / modify records in several tables. I'd like the email to contain the table name they have added to. How would I modify the above code to do that please?
Once I have the table name I presume I can use $hsh->{column_name} to put a bit more useful information into the email.
I'd also like to be able to send the user a confirmation email. Is there an easy way of getting the email address out of the users table?
Tim Ault
Oxford UK
Users in my db can add / modify records in several tables. I'd like the email to contain the table name they have added to. How would I modify the above code to do that please?
Once I have the table name I presume I can use $hsh->{column_name} to put a bit more useful information into the email.
I'd also like to be able to send the user a confirmation email. Is there an easy way of getting the email address out of the users table?
Tim Ault
Oxford UK