Hi All,
I am wrting a trigger, in which i need to invoke the external application using the MySQL Can anyone please help Urgent
Regards NewDev
+1
A:
Looking a your comment, the response is obvious. Write a program in whichever language you dominate the best. That program needs to
- Read all email addresses
- Iterate on the list
- Send a mail in every iteration
If you promise not to use it for sending spam, I can give you a basic PHP script to do that
The Disintegrator
2010-07-02 04:25:59
I know how i can i send using PHP.....Problem here is i want to write a trigger which on update in my configuration table should send the mail to required user
MySQL Rocks
2010-07-02 04:29:22
it has to be on server side......Client side i have already achived this
MySQL Rocks
2010-07-02 04:30:16
And what will update the configuration table? Surely a program... Make that program call the mailer
The Disintegrator
2010-07-02 08:40:44
Configuration table is updated by an external Engine written in C++; i do not want to integrate mailing to user with that engine.........
MySQL Rocks
2010-07-02 10:52:32
Make the external engine to CALL the program responsible of sending the mail. You could, in example, write a file in a specific place and make the program responsible of the mail to scan for that file. If found, mail.
The Disintegrator
2010-07-03 20:23:33
+1
A:
I would suggest having the external application request the list of users, and then looping through the list and sending the email. There's no real reason to mix the two.
zebediah49
2010-07-02 04:26:18