Member Avatar for altarek

I have database entrys that have a date column ( mySQL date type )
in this format(2011-5-30). I want to compare that date with the current server date and with 3 days before that day, to automatically send an email to a specified address.

Edited by altarek because: n/a
  • 2 Contributors
  • 3 Replies
  • 163 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by karthik_ppts
Member Avatar for karthik_ppts

I have database entrys that have a date column ( mySQL date type )
in this format(2011-5-30). I want to compare that date with the current server date and with 3 days before that day, to automatically send an email to a specified address.

select * from tbl_name where date_field_name=DATE_ADD(NOW(), INTERVAL 3 DAY)

Get all the mail ids from result set and send mails

Member Avatar for altarek

sorry I don't know how to compare dates then send email

Member Avatar for karthik_ppts

sorry I don't know how to compare dates then send email

Post your code with code tags

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.