I searched the forum and did not find any helpful information on this...Basically we want to send emails to users when certain information is updated. I am not a programmer so not sure where to start. The trigger functionality I can manage, but the email portion is where I am lost. From what I read mysql does not have this functionality so one must use php or perl or ? to accomplish this based on some cron job...So, which should I use? Can both be scheduled to run as cronjobs? From what I understand this is what I should do:

have a trigger monitor what we need and perhaps put that information is some kind of temp table
have a script of some fashion run at specified times and email the information in the table to users

?? That sound right? Can this be accomplished with perl?

php 5.1.6
mysql 5.0.27
2.6.19-1.2911.fc6
apache 2.2.3