
I see lots of tutorials about how to get the most recent comments in WordPress. Irrespective of how popular is your blog but it’s always good idea to show commenter’s gravatar in sidebar. Then what is the best way to show most recent comments on your WordPress blog with Gravatar?
Simply put below code to your theme’s file.
<?php global $wpdb; $query = "SELECT * from $wpdb->comments WHERE comment_approved= '1' ORDER BY comment_date DESC LIMIT 0 ,10"; // This shows top 10 comments $comments = $wpdb->get_results($query); if ($comments) { echo '<ul>'; foreach ($comments as $comment) { $url = '<a href="'. get_permalink($comment->comment_post_ID).'#comment-'.$comment->comment_ID .'" title="'.$comment->comment_author .' | '.get_the_title($comment->comment_post_ID).'">'; echo '<li>'; echo '<div class="img">'; echo $url; echo get_avatar( $comment->comment_author_email, $img_w); // Get Gravatar Image echo '</a></div>'; echo '<div class="txt">Par: '; echo $url; echo $comment->comment_author; echo '</a></div>'; echo '</li>'; } echo '</ul>'; } ?>
Let me know what you think about this.