Create You Own Get Recent Comments Widget

Couple of week ago, i upgrade my wordpress to new version, WordPress 2.5. All my plugin didn’t problem, but Get Recent Comment Plugin showing error message. I try to update it but still getting error. I install similiar plugin also showing same error. Luckily i found this piece of code in tutorialtheme that can display god list of recent comment.

Here is the code to display recent comment :

global $wpdb;

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

$output = $pre_HTML;
$output .= "\n
foreach ($comments as $comment) {

$output .= "\n
.":" . " <a href="\">ID) .
"#comment-" . $comment->comment_ID . "\" title=\"on " .
$comment->post_title . "\">" . strip_tags($comment->com_excerpt)

$output .= "\n</ul>
$output .= $post_HTML;

echo $output;


You can configure how many character that you want to display by changing this line :

SUBSTRING(comment_content,1,30) AS com_excerpt

value 30 mean only fist 30 charactar will display.

You see the demo on side bar in this blog.

Copy this code to your PHP widget.

You may also like...

2 Responses

  1. Thanks, I’ll try it soon. Usually upgrading to a new version of wordpress will have plugins problem.

    Halim-Belajar SEOs last blog post..Belajar SEO got a grade B+

  2. Escoofield says:

    Wow that’s amazing! thank you very much!

Leave a Reply

Your email address will not be published. Required fields are marked *