<div>
<div class="content wysiwyg-content">
Hello<br />
I want to display a count of approved users in a Drupal 7 site. I'm using PHP to do this.<br />
I have the following <br />

<pre><code id="code-10-28547614-1">&lt;?php $members = db_query(&quot;SELECT count(uid) FROM {users}&quot;)-&gt;fetchField(); echo &quot;$members&quot;; ?&gt; </code></pre>
This is giving me all members, approved or not. How do I show only the members that have been approved for membership?<br />
<br />
Thank you
</div>
</div>


Hello
I want to display a count of approved users in a Drupal 7 site. I'm using PHP to do this.
I have the following 
(CODE)
This is giving me all members, approved or not. How do I show only the members that have been approved for membership?

Thank you

Show a count of registered users in Drupal 7

Drupal is an open-source content-management framework written in PHP used as a back-end framework for websites and is also used for knowledge management and business collaboration. The standard release of Drupal contains basic features common to content management systems, including user account registration and maintenance, menu management, RSS feeds, taxonomy, page layout customization, and system administration. Drupal runs on any computing platform that supports both a Web server capable of running PHP and a database to store content and configuration.

Drupal

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.