Hide Non Activated Users From Member List

[ZiNgA BuRgA]

Do a select COUNT(*) (also, ordering doesn't make any sense here)

PHP Code:

$query = $GLOBALS['db']->simple_select('users','COUNT(*) AS num_users','usergroup!=5'); $activeusercount = $GLOBALS['db']->fetch_field($query, 'num_users');

---

Note that you may wish to put an index on the usergroup column if you do this, as the query can be slow if there are a lot of users.