I have a table for instructors which contains subjects, date and time and Status information about their classes.
Once they register on the website they get the pending status, and somebody from administration either Approve, deny or Cancel their class.
so the status changes from Pending to either Approv, deny Or cancel.
I want to write a query that to piush the information to instructors if their Status gets changed from Pending to Approve, Deny Or Cancel
How do I do that.