Wednesday, August 4, 2010

Display Most Popular Posts in WordPress

Place below code where you want to display your Most Popular Posts:

<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 , 5");
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 } } ?>

Just change the 5 in line 3 to change the number of displayed popular posts. That’s it.

Post a Comment

Popular Posts