Adastra Posted July 10, 2006 Share Posted July 10, 2006 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? :) Quote Link to comment https://forums.phpfreaks.com/topic/14151-selecting-doing-something-for-one-row-value-per-row/ Share on other sites More sharing options...
AV1611 Posted July 10, 2006 Share Posted July 10, 2006 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... Quote Link to comment https://forums.phpfreaks.com/topic/14151-selecting-doing-something-for-one-row-value-per-row/#findComment-55442 Share on other sites More sharing options...
GingerRobot Posted July 10, 2006 Share Posted July 10, 2006 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 Link to comment https://forums.phpfreaks.com/topic/14151-selecting-doing-something-for-one-row-value-per-row/#findComment-55443 Share on other sites More sharing options...
Adastra Posted July 10, 2006 Author Share Posted July 10, 2006 [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... ^^ Quote Link to comment https://forums.phpfreaks.com/topic/14151-selecting-doing-something-for-one-row-value-per-row/#findComment-55533 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.