webprof

I need some help with this : I have a SQLdatabase with records. Each record has several fields; also a field emailadres and a field status. I need a script which allows me to change the status of a certain record. After changing the status, the application should send an email message to the email adres, informing the person that the status has been changed