Thank you for the blog comments!

Posted on by
WordPress Session at Podcamp Ohio
Image by danieljohnsonjr via Flickr

In preparation for this weekend’s 4-year anniversary episode of the Journey Inside My Mind podcast, I’ve gone through the comments made on this blog, and have produced this list. It was compiled from the MySQL database that powers my WordPress blog, with the query:

SELECT DISTINCT `comment_author` , `comment_author_url`
FROM wp_comments
ORDER BY `comment_author` ASC

After cleaning up the list in Excel, I’ve got this of everyone who has commented and has left a link. Thank you to everyone who has been involved over the past four years or more:

I think I’m going to try this out for my other blogs as well.  Thanks also to Chris Penn for the idea.

Possible related articles by Zemanta
Reblog this post [with Zemanta]

  • Pingback: How I spent 2009 - in blog posts | Daniel Johnson, Jr.

  • http://gisnap.com gisnap

    Its really cool, I came to know this really worth visiting, just bookmarked your site.

    http://gisnap.com/
    The place where fun never ends

  • Tony Scarcia

    Hi, I used your code, with many thanks: my question is, how do I put a space between the author’s name and the comment excerpt?

    thank you on advance for your help.
    Tony Scarcia

    PS: Here is the code, thanks.————————————————————-RECENT COMMENTScommentsLEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID =$wpdb->posts.ID)WHERE comment_approved = ’1′ AND comment_type = ” ANDpost_password = ”ORDER BY comment_date_gmt DESCLIMIT 10″;$comments = $wpdb->get_results($sql);$output = $pre_HTML;$output .= “n”;foreach ($comments as $comment) {$output .= “n”.strip_tags($comment->comment_author).”:” . “ID) .”#comment-” . $comment->comment_ID . “” title=”on ” .$comment->post_title . “”>” . strip_tags($comment->com_excerpt).”“;}$output .= “n”;$output .= $post_HTML;echo $output;?>

  • http://danieljohnsonjr.com danieljohnsonjr

    If I remember correctly, I did that by hand. I just used the script to get the names. To add a space, though, you might just use the + as a concatenation character. authorname+’ ‘+comment

    Thanks for commenting. Let me know how it goes!