Mysql PHP help?

mysql triggers works

[rootlk]

Can someone post a simple example of how a trigger can be built to send an email on update of a table row?

[Matthew1980]

Hi there Rootlk,

Welcome to WebmasterWorld!

An example, in pseudo form:-

<?php

//If the query is successful, and the sql returns true on completion of query
//send a mail

if($update_query){
if(mail(SEND YOUR EMAIL HERE)){
echo "Update complete";
exit;
}
else{
echo "Something went wrong";
exit;
}
}
else{
//something went wrong, show error or redirect to holding/index page
header(REDIRECT HERE);
exit;
}
?>

That will be something like the logic as you need there.

Cheers,
MRb

[rootlk]

thx for the well come,
and
thx for the support