Match the News title with user, then sends user the email
Posted: Fri Apr 24, 2009 12:31 am
Hello everyone,
I am a newbie here. Hope to learn from all of you.
I have only very basic php skills, like store, delete items in database.
My website is sort of a newspaper.. which is constantly updated with the latest news.
I stored all these news in a table called "LatestNews"
It has 2 fields: "Title" and "Body"
I also have users that subscribe. My users can also store up to 5 of their favorite "keywords" into the MySql.
I stored all these data in table called "Users"
It has a 3 fields like "Name", "Email" and "favoritewords"
Scenario
Lets say, the user enters in "BMW" into his favourite words.
then lets say..... i posted a news, with the title BMW cars for sale.
It will automatically sends my user an alert email about the latest news I posted.
How can I do that ?
are there any scripts out there ?
Thanks so much
I am a newbie here. Hope to learn from all of you.
I have only very basic php skills, like store, delete items in database.
My website is sort of a newspaper.. which is constantly updated with the latest news.
I stored all these news in a table called "LatestNews"
It has 2 fields: "Title" and "Body"
I also have users that subscribe. My users can also store up to 5 of their favorite "keywords" into the MySql.
I stored all these data in table called "Users"
It has a 3 fields like "Name", "Email" and "favoritewords"
Scenario
Lets say, the user enters in "BMW" into his favourite words.
then lets say..... i posted a news, with the title BMW cars for sale.
It will automatically sends my user an alert email about the latest news I posted.
How can I do that ?
are there any scripts out there ?
Thanks so much