update database with success or failure message
I have selected the update database on universal email success or failure, but database if not updated.
There were some instances of mysql_connect in place of mysqli_connect which I have manually rectified.
First, the database can have more than one row with same email, so the update has to work with ID. Secondly, I also need to update another column in db with date when the db is updated. This is to make sure I have record of when email was sent to that particular ID.
I have provided files in attachment for your reference.