Jump to content

Archived

This topic is now archived and is closed to further replies.

Adastra

Selecting / Doing something for one row-value per row?

Recommended Posts

I've written a new small function to send someone an email when a follow-up comment is made on a bloglike thing, but I would like to send them only ONE e-mail per entry, or per e-mail address, in case they signed up for a follow-up more than once.

How exactly can I do that? I can't think of any function in PHP (I'm still a noob), and I also don't know how to approach this in SQL.
I thought something like "SELECT * FROM blog_comments WHERE entry=$entry AND followup='yes' and COUNT(email) >= 1" might work, but I get an error with that statement.
Anyone got any better ideas? :)

Share this post


Link to post
Share on other sites
you could add a field to table called "SENT_EMAIL" and mark it true and maybe a date so you can decided if you've sent an email, and how long ago...

Share this post


Link to post
Share on other sites
Another way would be to store all the emails in an array,  then use the array_unique() function to remove duplicate entries.

You could then send an email to each of those.

Share this post


Link to post
Share on other sites
[quote author=GingerRobot link=topic=100024.msg394309#msg394309 date=1152525187]
Another way would be to store all the emails in an array,  then use the array_unique() function to remove duplicate entries.

You could then send an email to each of those.
[/quote]
How exactly does that work? Do you have a code sample? Sry, I'm such a noob... ^^

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.