Title: BETTER CODE for $item_count
Last modified: August 31, 2016

---

# BETTER CODE for $item_count

 *  [protodevsystems](https://wordpress.org/support/users/protodevsystems/)
 * (@protodevsystems)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/better-code-for-item_count/)
 * Hi Larry,
 *  Great plugin! I am using it and very nice work. Though, I just noticed some 
   better tweaks on the codes for the item_count variable:
 *     ```
       $query = "SELECT count(*) FROM <code>&quot;.$wpdb->prefix.&quot;users</code> u LEFT JOIN <code>&quot;.$wpdb->prefix.&quot;usermeta</code> um ON u.ID=um.user_id ";
       $query .= "WHERE um.meta_key = '".$wpdb->prefix."capabilities' AND (";
       foreach ($this->options['display_roles'] as $key => $value) {
       	if ($value) $query .= " um.meta_value LIKE '%".$key."%' OR";
       	}
       $query = substr($query, 0, strlen($query) - 3).") ";
       $count = $wpdb->get_var($query);
       $item_count = $count.' vendor';
       if ($count !=1) $item_count .= 's';
       ```
   
 * Hope this helps.:) and thank you very much for this plugin.
 * [https://wordpress.org/plugins/dmc-user-list/](https://wordpress.org/plugins/dmc-user-list/)

The topic ‘BETTER CODE for $item_count’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/dmc-user-list_858e99.svg)
 * [DMC User List](https://wordpress.org/plugins/dmc-user-list/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/dmc-user-list/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/dmc-user-list/)
 * [Active Topics](https://wordpress.org/support/plugin/dmc-user-list/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/dmc-user-list/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/dmc-user-list/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [protodevsystems](https://wordpress.org/support/users/protodevsystems/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/better-code-for-item_count/)
 * Status: not resolved