2. PHPRunner General questions
  3. [SOLVED]  Birthday wish email with attachment
This topic is locked
[SOLVED]

 Birthday wish email with attachment

 		10/15/2016 9:22:18 AM
PHPRunner General questions
A
 azmi author

Hi Everyone,
Is there any easy way to send birthday card or send a birthday wish message to client on his/her birthday?
SELECT Client_Name, Client_DBO from client where MONTH(Client_DBO)= 10
Any help highly appreciated.
Sergey Kornilov admin 10/19/2016

Not sure I understand what your question is. Are you asking how to select a list of clients that have a birthday today?

If your database is MySQL this is what you can use:

SELECT * FROM mytable WHERE DATE(posted) = CURDATE()


More info and examples:

http://xlinesoft.com/blog/2014/11/12/datetime-handling-in-web-applications/