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
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
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 ----
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.