Add number of members to “Right Now” dashboard widget

Question

Problem

I have this code in functions.php but it does not output the total number of members (something is wrong with it it breaks the site) in my "Right Now" dashboard. Is there a way to fix it?

function dashboard_wps_user_count() {
global $wpdb;
$users = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users");
?>
<table>
<tbody>
   <tr class="first">
      <td class="first b b_pages"><a href="users.php"><? echo $users; ?></a></td>
      <td class="t pages"><a href="users.php">Members</a></td>
   </tr>
 </tbody>
</table>
<?}
add_action( 'right_now_content_table_end', 'dashboard_wps_user_count');

Additional feature

Also is there a way to show how many authors are registered and how many subscribers are registered also in the "Right now " dashboard?

Answer 1

So here is the small snippet to show total number of users and all roles with user count. This code should go in the themes functions.php file.

The code uses count_user function to fetch the array and show it up on Right Now dashboard screen.

function wpse_60487_custom_right_now() {
    $users = count_users();
    echo '<table><tbody>';
    echo '<tr><td class="first b b_pages">'.$users['total_users'].'</td><td class="t pages"> total users</td></tr>';
    foreach($users['avail_roles'] as $role => $count)
    echo '<tr><td class="first b b_pages">'.$count.'</td><td class="t pages">'.$role.'</td></tr>';
    echo '</tbody></table>';

 }
add_action( 'wpse_60487_custom_right_now', 'dashboard_wps_user_count');