Forum Moderators: coopster

Message Too Old, No Replies

Email Notification when row is Edited or Added

Email Notify

         

paseo

7:25 pm on Dec 21, 2006 (gmt 0)

10+ Year Member



Does anybody know of any internal or external "functions" or scripts that will allow an email to be sent when a row is either modified or added to a table in a MYSQL Database?

henry0

7:35 pm on Dec 21, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If a row is added then it is an INSERT
If a row is modified then it is an UPDATE

you could use at the end of you query (both cases)
$result
if $result OK then pass an email
else
echo a failure/warning message

At WebmasterWorld we do not use too many "one solution fits all"
so we do not have pre-made scripts
but we will be more than happy to look at what you have and help you develop a script tailored to your need

Post first how your DB is queried
and how rows could be either updated or added.