tracking system function HELP

[immerz]

hey guys,

I'm going to be making a tracking system, just wanted to know is there some function or something in PHP which will allow an automatic email notification to be sent to particular user(s) when a record of some type has changed status and the record is save.

E.g When I change the status of a record from planning to approved: then hit save. And once saved an email will be sent to Mr ABC telling them the record has been approved? Can this be done??

Thanks in advance,

Cheers.

[Kudose]

You could use the [man]mail[/man] function right after your update query. You would need to run a query or two to get the email address you will be mailing though...

If you provide a basic database layout and a form I can help you figure it out...