Richard Castera

Easily list the most recent comments in a sidebar or a tab. The code below will list the 10 most recent comments. You can change the number displayed by changing the value of the variable, $intCommentLimit to list more or less comments

<?php
function getRecentPosts() {
    global $wpdb;
    $intCommentLimit = 10;

    $strSql = "SELECT DISTINCT ID, 
                      post_title, 
                      post_password, 
                      comment_ID, 
                      comment_post_ID, 
                      comment_author, 
                      comment_date_gmt, 
                      comment_approved, 
                      comment_type, 
                      comment_author_url, 
                      SUBSTRING(comment_content, 1, 50) AS com_excerpt 
               FROM $wpdb->comments
               LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) 
               WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT $intCommentLimit";

    $comments = $wpdb->get_results($strSql);
    $strOutput = "<ul>\n";

    foreach ($comments as $comment) {
        $strOutput .= "<li>" . strip_tags($comment->comment_author)  . " Says, <br />" . 
                      "<a href=\"" . get_permalink($comment->ID) . "#comment-" . 
                      $comment->comment_ID . "\" title=\"on " .
                      $comment->post_title . "\">" . 
                      strip_tags($comment->com_excerpt) . " ...</a></li>\n";
    }

    $strOutput .= "</ul>\n";
    return $strOutput;
}

echo(getRecentPosts());
?>