So I just created a way for Members to "subscribe" to an Article so they get updates whenever other Members add a Comment.
Now I need to build the code that actually notifies them that a new Comment was added.
What I am wondering about is this...
What is the best way to take a series of E-mails from an MySQL Query and get it into an E-mail notifying everyone that subscribed to that Article that a new Comment was posted?
1.) I am not sure how to physically get the database query result-set into the mail() function/program.
2.) I suppose I need to be extra careful of people's privacy, and even if I am e-mailing 20 people, each recipient should think the notification is *only* coming to them, and they should NOT be able to see other Members' E-mails!!!
Can someone help get me started on this?