tags:

views:

88

answers:

1

Hi All,

I want to sent email on DB field changes.....Can any please let me know how can i do it in PHPmyAdmin.

Regards, Hemant

A: 

phpMyAdmin is just a web administration frontend for MySQL. You could probably write a stored procedure and register it with a trigger which will send the notification of a row change.

In my opinion this should be done in your application logic rather than the database.

Also see http://stackoverflow.com/questions/387483/how-to-send-email-from-mysql-5-1

joschi
i am working on web based application in which if you user put request... and and processed but user also have option of putting the new request if UI is not running than mail is not send do i want to handle it in Database.....so that is a required field changes than mail should be sent.........Can you please provide a Small example
MySQL Rocks