Link to home
Start Free TrialLog in
Avatar of Gee Jay Almestas
Gee Jay Almestas

asked on

Auto Send Email notification to Specific SQL Table Column?

Hi, is it possible to send email notification to specific sql table column? automated sql query or php or js etc...

let say i have a table column named user id, name, email & expired date

---- USER ID ---- NAME ---- EMAIL ---- EXPIRED DATE ----
---- 1 ---- Jay ---- jay@email.com ---- 09/13/2015 ----
---- 2 ---- Josh ---- josh@email.com ---- 09/14/2015 ----
---- 3 ---- Steve ---- steve@email.com ---- 09/13/2015 ----

Open in new window


so if Name = Jay which has user id = 1 reached EXPIRED DATE = 09/13/2015 then Notification will send an email to specific group like admin, editor and author(WordPress Groups) or specific multiple emails that Name = Jay with user id = 1 has been expired.

and if possible will send to users email also.

thank in advance
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial