How To Display Popular Post In WordPress Blog

Posted by


Sidebar is a very good element of the blog from where web users can find most of the details instead of search. In order to display most popular post in sidebar of the blog edit the sidebar.php file and add this code where you want to display in the sidebar.

<h2>Popular Posts</h2>
<?php $result = $wpdb->get_results(“SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 10”);
foreach ($result as $post) {
$postid = $post->ID;
$title = $post->post_title;
$commentcount = $post->comment_count;
if ($commentcount != 0) { ?>
<li><a href=”<?php echo get_permalink($postid); ?>” title=”<?php echo $title ?>”>
<?php echo $title ?></a> {<?php echo $commentcount ?>}</li>
<?php } } ?>

This code will display 10 most popular posts of the blog. You can change the number as per requirement.

That’s it!


Shane G.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.