Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I want to list authors with last post data and order them by last post date. Now i have this codes but i don`t know how to edit them.

// Selects from tables wp_users and wp_posts, selecting published posts and ordering by its post_date, limited to 10
        $querystr = "SELECT * from wp_users, wp_posts WHERE wp_users.ID = wp_posts.post_author AND wp_posts.post_type = 'post' AND wp_posts.post_status = 'publish' ORDER BY wp_posts.post_date DESC LIMIT 10";

          $news=$wpdb->get_results($querystr, OBJECT);

          foreach($news as $np)
          {
            $authorID = $np->authorID;
            $author_nickname = $np->user_login;
            $author_displayName = $np->display_name;
            $author_niceName = $np->user_nicename;
            $post_id= $np->postID;
            $post_title= $np->post_title;
            $post_date= $np->post_date;

or this :

<?php
//displays all users with their avatar and their posts (titles)
$blogusers = get_users_of_blog();
if ($blogusers) {
foreach ($blogusers as $bloguser) {
$user = get_userdata($bloguser->user_id);
echo '<p>User ID ' . $user->ID . ' ' . $user->user_firstname . ' ' .      $user->user_lastname . '</p>';
  echo get_avatar( $user->ID, 46 );
  $args=array(
  'author' => $user->ID,
  '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() ) {
  //echo 'List of Posts for ' . user->user_firstname . ' ' . $user->user_lastname;
  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().
}
}
?>
share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.