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 :


<?php
global $wpdb;

$sql = "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,30) AS com_excerpt
FROM $wpdb->comments
LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID =
$wpdb->posts.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
<ul>";
foreach ($comments as $comment) {

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

}
$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.

About the author

Related Post

2 Comments

  1. Escoofield

    Wow that’s amazing! thank you very much!

Leave a comment

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