Topic awaiting preservation: Mailing List Managers

Hi

I want to add a text field to my site where folks can enter their email addresses, choose a coupon category (clothes, computers, etc.) and this info get stored into my existing mysql dbase. When people's categories come arounf, I want to send out emails.

I know hotscripts has many of these types of scripts but I was wondering if any of you have more experience with this and can recommend a script.

Thanks!

(Edited by CRO8 on 08-18-2004 01:43)

what do you mean by categories come around?

the script is simple, you need to make a normal form and insert details into db, then (i'm guessing this is what you mean) whenever a new item is added to a category, email people subscribed to that category, could you not write a script that did this:

when you add a new product to categories, select everyone who has subscribed to that category and email them a simple email, saying new product added???

make any sense?

thats pretty much it - yeah whenever I get a new coupon in the category they are interested in, I would like to be able to email them to notify them of this new coupon. maybe I dont need a full list mailer but a simple php script?

what i would do is write a php script as follows:

$query = "insert into categories values(insert product values)";

$result = mysql_query($query);



if(mysql_affected_rows($result) < 0) {

  // data went into database

  mail (select all people subscribed to this category and email them);

  }

else {

  echo "could not add products to categories";

  }

help any??

---------------------------------------------------------------------------------------------------------------------
Need a web site made? don't have much $$$ to spend? I have 3 spaces to fill as I am looking to increase my portfolio! I will make your site for you.

Visit 10/6 Web Solutions today!

thanks - let me play around and re-post.

thanks.

hey kronk- thanks. where would I place my variation of this script? I assume on the page that they are entering their email, coupon category interest . . .? hmmm. well it has to execute whenever a category comes into dbase . . . thanks!

(Edited by CRO8 on 08-24-2004 12:10)