Email all Repliers (3 posts)

  1. ComputerGuru
    Posted 9 years ago #

    I recently wrote an article about a Firefox bug (http://neosmart.net/blog/?p=111) and I need to send an email to everyone that commented there and let them know there is a solution.
    Is there a quick PHP script I can use that would output a comma-delimited list of all email addresses in the reply for post number 111? There are 113 replies, and I can't realistically copy and paste them 1 by 1.

  2. FruitFly
    Posted 9 years ago #

    I'm not sure about a PHP script, but this info could be gathered from phpMyAdmin in seconds. Despite your nickname, I don't know how familiar you are with phpMyAdmin, so I'll give you some basic instructions. Apologies if I'm erring on either side - if it's too generic, post back and I'll see if I can help more. :)

    Login to phpMyAdmin and go to the table wp_comments, click the SQL tab at the top, and put in the following query:

    SELECT comment_author_email FROM wp_comments WHERE comment_post_ID = "XXX"

    Substituting the XXX for the post ID you're trying to get the info for. You should then be able to export the results into a CSV file to work with.

  3. ComputerGuru
    Posted 9 years ago #

    Thanks FruitFly.. I guess I should have been more specific, I was looking for JUST that.... I am not familiar with the WP database, and was wondering if there was a column for that. (comment_author_email that is)


Topic Closed

This topic has been closed to new replies.

About this Topic