Closed Thread Icon

Topic awaiting preservation: Mailing List Managers Pages that link to <a href="https://ozoneasylum.com/backlink?for=22965" title="Pages that link to Topic awaiting preservation: Mailing List Managers" rel="nofollow" >Topic awaiting preservation: Mailing List Managers\

 
Author Thread
CRO8
Bipolar (III) Inmate

From: New York City
Insane since: Jul 2000

posted posted 08-18-2004 01:41

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)

kronk
Bipolar (III) Inmate

From: Sydney, Autralia
Insane since: Jun 2004

posted posted 08-18-2004 04:47

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?

CRO8
Bipolar (III) Inmate

From: New York City
Insane since: Jul 2000

posted posted 08-18-2004 12:55

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?

kronk
Bipolar (III) Inmate

From: Sydney, Autralia
Insane since: Jun 2004

posted posted 08-18-2004 18:00

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

code:
$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!

CRO8
Bipolar (III) Inmate

From: New York City
Insane since: Jul 2000

posted posted 08-19-2004 04:01

thanks - let me play around and re-post.

thanks.

CRO8
Bipolar (III) Inmate

From: New York City
Insane since: Jul 2000

posted posted 08-24-2004 12:05

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)

« BackwardsOnwards »

Show Forum Drop Down Menu