I have a loop where I post list of authors with SQL Query. I also need to post the_author_posts_link
with links to author pages. When I put it into loop it renders only the 4th entry for every iteration:
foreach ($all_users_id as $i_users_id ) :
$user = get_userdata( $i_users_id );
the_author_posts_link();
$email = $user->user_email;
echo $email;
?>
<?php endforeach; ?>
Why not work with an existing wordpress template tag?: Template Tags/wp list authors « WordPress Codex
Edit: Gravatars: Search WordPress Plugins >> gravatars