We need a MySQL trigger written. Here is what it needs to do:
1. The trigger fires upon insertion to a table.
2. The trigger reads data from the inserted record (order). It has to do a join to get data from a referenced table (product) as well.
3. The trigger reads configuration data from another table. (email address to send to, email text)
4. The trigger emails the data in the record to the email address specified in the configuration record.
This is a MySQL db running on Linux. The database supports a low-valume Joomla website.
18 freelancers are bidding on average $100 for this job
morning I have developed a webmail based on MySQL backed Ajax and triggers on db to dinamically refresh grids when new mail has been recorded on the db let me know regards Paolo