Show Authors and excerpt of their last post in a list

Question

Hi All,

I've search everywhere but haven't found what I'mlooking for even though I'm convinced there must be a solution floating around since it's obviously such a common request:

I want to display a list of authors with a short excerpt of their latest post.

I have a list of Authors with their images (using the 'Author Avatars List') but what I'm missing is the display of an excerpt of their latest posts next/under their image.

Any thoughts?

Thanks in advance! JD

Edit 26 Sept

I realize from the First two answers my question was a bit to fuzzy - the emphasis should have been on the 'authors avatars list' wp plugin (http://wordpress.org/extend/plugins/author-avatars/).

In the meantime I have created the following solution: http://wordpress.org/support/topic/plugin-author-avatars-list-get-display-excerpt-of-authors-last-post?replies=2#post-1710752

Thanks for you input! JD

Answer 1

From get_posts() , you can get all the posts , since each post has a post_author property, you can get all the posts written by each author with a foreach loop, from this you get the latest post per author , and from the latest post , get the post_excerpt content.

Assuming you're using Wordpress...

Answer 2

I'd do a hybrid direct SQL and loop approach.

Query for user_ids from the user table who also have a post_author present in the posts table. Loop over those IDs to get their user object and then their latest post. The only thing you lose here is fine grained control over the ordering of users.

Answer 3

Here is the solution:

http://wordpress.org/support/topic/plugin-author-avatars-list-get-display-excerpt-of-authors-last-post?replies=2#post-1710752

Greets

JD