How to Show One Latest Post Per Author on Wordpress Front Page

smallwei 6:57 am on January 21, 2010 | Answers: 1    
Tags: author (2), blog (4), page (14), post (3), wordpress (15)

Rate Knowledge:

 Loading ...

• smallwei 6:57 am on January 21, 2010
  

  Basically, you you use the combination of query_posts and posts_where filter to do the trick. The query_posts needs to be right before “The Loop”. Use this code on your index.php template file.
  

    <?php
    //Displaying latest post per author on front page
    function filter_where($where = '') {
      global $wpdb;
      
      $where .= " AND wp_posts.id = (select id from {$wpdb->prefix}posts p2 where p2.post_status = 'publish' and p2.post_author = {$wpdb->prefix}posts.post_author order by p2.post_date desc limit 0,1)";
      return $where;
    }
    add_filter('posts_where', 'filter_where');
    query_posts($query_string);
  
  //The Loop
  if ( have_posts() ) : while ( have_posts() ) : the_post();
  
  ...
    ?>