I have a SQL database named Courier_Form with a dozen fields in it. I have a smallint field named Email_Sent_To_Customer, a date field named Completion_Date, and a vchar(80)field named Requester_Email. I am trying to find a way to send an email to the Requester_Email Address when the date in the Completion_Date field is populated and then I want the value in the Email_Sent field to also be changed to '1'.
I am trying to automate an email to the customer when there job is completed and don't want to send multiple email so I want to populate a field that lets me know that I have already sent an email to this person for this job.
I am brand new to programming and PHP so any help or assistance is greatly appreciated.
I am using PHP Runner 8.0, MSSQL database 2012.