Email not sending ... trigger issue?
This process updates 2 separate records in the users table, inserts a transaction into the transactions table, grabs the last transaction entered into the transaction table, and emails the users involved with that transaction details. The problem is, the email is not sending.
Can you see why this is not working? Does it have something to do with the trigger, Successful update? How can I get this email to be sent the very last thing, after the update and insert scripts run? Ignore all of the testing echo code output, FYI. Code is attached.
Also, it's not redirecting, probably because the email isn't being sent???
Thank you.