I have a table that accepts article and email from a user and another table that accepts the name and comments from another user. I want the first user(the person who post the article to recieve email that someone has commented on the article.
I will appreciate it if you can write out the pseudo code e.g
//query your db,left join the two tables
//blah blah
something like that, and i will even appreciate it more if it's the code or something.
Just as daniweb sends email to me when u reply to my post. Thanks