Support » Fixing WordPress » Most Popular in one category

  • Resolved mkjar

    (@mkjar)


    Is there a way that I can get only the most popular posts in specified category? the code I am using currently in template is below:

    <h2>Most Popular</h2>
    <ul class="mostpop">
    <?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></li>
    <?php } } ?>
    </ul>

    thanks for your help!!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Assuming by popular you mean the post with the most comments then this should get the post with the highest comment count for a given category

    <?php
    $cat_id = get_cat_ID('your-category-here');
    $args=array(
      'cat' => $cat_id,
      'orderby' => 'comment_count',
      'order' => 'DESC',
      'post_type' => 'post',
      'post_status' => 'publish',
      'posts_per_page' => 1,
      'caller_get_posts'=> 1
    );
    $my_query = null;
    $my_query = new WP_Query($args);
    if( $my_query->have_posts() ) {
      while ($my_query->have_posts()) : $my_query->the_post(); ?>
        <p><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></p>
        <?php
      endwhile;
    }
    wp_reset_query();  // Restore global post data stomped by the_post().
    ?>

    The user was pulling 10 posts in the original query Michael..

    'posts_per_page' => 10,

    A pre-emptive response to “The query is only returning one post”… 😉

    thanks!

    You are welcome. Marking this resolved.

    it worked like a charm! thanks so much!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Most Popular in one category’ is closed to new replies.