Advanced Search

Return to Snippet

Revision: 11571
at February 9, 2009 15:57 by selfmadepsyche
Initial Code 
<h2>Most commented posts from 2008</h2>
<ul>
<?php
$result = $wpdb->get_results("SELECT comment_count,ID,post_title, post_date FROM $wpdb->posts WHERE post_date BETWEEN '2008-01-01' AND '2008-12-31' ORDER BY comment_count DESC LIMIT 0 , 10");

foreach ($result as $topten) {
    $postid = $topten->ID;
    $title = $topten->post_title;
    $commentcount = $topten->comment_count;
    if ($commentcount != 0) {
    ?>
         <li><a href="<?php echo get_permalink($postid); ?>"><?php echo $title ?></a></li>
    <?php }
}
?>
</ul>
Initial URL 
http://www.wprecipes.com/how-to-display-the-most-commented-posts-of-2008
Initial Description 
To display a list of your 10 most commented posts from 2008, simply paste the following code on your blog sidebar, or anywhere on your theme.
Initial Title 
Display the most commented posts
Initial Tags 
wordpress
Initial Language 
PHP