database monitor to email users

[Anon]

I am looking at attempting to implement a system that will monitor my database. I want my users to put what they want to watch for and when/if it gets put into the database, it will email them. I want to make it available to all my users.

Anyone know of a system like this or can make 1 real quick? I am willing to pay someone to do this.

I already have a database for it to monitor. But I am assuming this would need its own database to store the users requests. I can run a script every nite at like 12pm to do the poll/email

Thanks guys
J

[Anon]

please someone help me.. this seems pretty easy. Just a page that stores users/pass and email and item to monitor for.

the only features is the ability to change pass/email and add or delete items.

the pass system can be plain text too.

my email is [e-mail]

thanks again

[heliumflash01]

Joe -

An important aspect of this project is just how the users will specify what to watch out for. Is it going to be an existing product, with a product ID, that's out of stock currently? Or maybe the SKU of a product that they've seen elsewhere? To automate it, it would be far better to have a simple criterion to run a match on, like an ID.

If that's the case, you could just create another table to hold the user ID and the product ID they're looking for. Whenever a product gets added, a check is run (by product ID) against your waiting list table; you retrieve all the applicable user IDs of people waiting for that product. Then just grab the email address from the user table, and shoot off an email using PHP's built-in functionality.

-Jeremy