Email all Repliers

  • mqudsi

    (@computerguru)


    18 years, 7 months ago

    Hi.
    I recently wrote an article about a Firefox bug (https://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.

Viewing 2 replies - 1 through 2 (of 2 total)

  • 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.

    Thread Starter mqudsi

    (@computerguru)

    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)

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Email all Repliers’ is closed to new replies.

Tags