How to add 10 hot wordpress posts
April 1st, 2010 — adminIf you want to add 10 host post at your right bar, just copy and past the following code:
<h2>Hot PHP Posts</h2>
  <ul>
    <?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) {
     setup_postdata($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 } } ?>
  </ul>