2

Hello I have a php/mysql project in which I have a database table that keeps track of events. I want to send an email to interested parties when a change is made to an event. The email would state what changed ex: time, location, etc.

What is best approach? I don't need a revision history. Just the diff between previous and updated version.

Andre
  • 21
  • 1
  • how many users u intend to sent email to ? this potentially kill your apps/page speed if u have huge list of user – ajreal Nov 11 '10 at 15:05
  • an example of background process - http://stackoverflow.com/questions/45953/php-execute-a-background-process – ajreal Nov 11 '10 at 15:08

1 Answers1

0

I would put any emailing method in the function which actually changes the event. So it would first SELECT the event to be changed, compare it to the posted data, then UPDATE it, and if the UPDATE all went smoothly, email the comparison in a pretty format.

Nathan MacInnes
  • 11,033
  • 4
  • 35
  • 50