Latest Comments

<?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,50) // NUMBER OF CHARACTERS
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 5″; // NUMBER OF COMMENTS
$comments = $wpdb->get_results($sql);
$output = $pre_HTML;
$output .= “\n< ul>”;

foreach ($comments as $comment) {
$output .= “\n< li>”.”< a href=\”” . get_permalink($comment->ID) .
“#comment-” . $comment->comment_ID . “\” title=\”on ” .
$comment->post_title . “\”>” .strip_tags($comment->comment_author)
.”:
<div>” . strip_tags($comment->com_excerpt)
.”</div></ a></ li>”;
}
$output .= “\n”;
$output .= $post_HTML;
echo $output;
?>


Latest Comments