jbalanski
asked on
Email notification when record added
Hi does anyone no how to get email notification when a record is added.
I have a application that pushes data to mysql, I would like to be notified when a record is added. I am thinking of a shell script, or a php script that we can run every 30 minutes.
Or the other way would be to check the database and if unit id doesn't have todays date as a record it would email us.
We are running mysql 4 on OpenBSD 3.8
I have a application that pushes data to mysql, I would like to be notified when a record is added. I am thinking of a shell script, or a php script that we can run every 30 minutes.
Or the other way would be to check the database and if unit id doesn't have todays date as a record it would email us.
We are running mysql 4 on OpenBSD 3.8
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
if we don't get data from a particular device then we would like to know........i will look into the binary log and see what we have there