Query to print count user from usergroup

[Muhammad Rahman]

like thread title,
anyone know query to display count user from usergroup.

[vBNinja]

PHP Code:

SELECT COUNT(userid) amount 
FROM user 
WHERE usergroupid = X OR FIND_IN_SET(X, membergroupids); 


Change "X" to the usergroup ID you need

[Muhammad Rahman]

Originally Posted by vBNinja

PHP Code:

SELECT COUNT(userid) amount 
FROM user 
WHERE usergroupid = X OR FIND_IN_SET(X, membergroupids); 


Change "X" to the usergroup ID you need

not working, only display "Array" ..

this my code, whats wrong

PHP Code:

$usg = $vbulletin->db->query_first("SELECT COUNT(userid) amount 
FROM " . TABLE_PREFIX . "user 
WHERE usergroupid = 6 OR FIND_IN_SET(6, membergroupids)");

$templater = vB_Template::create('usg_temp');
$templater->register('usg', $usg);    
$usg_display .= $templater->render();

$template_hook[forumhome_above_forums] .= $usg_display; 


[mokujin]

Use {vb:raw usg.amount} in your template?

[Muhammad Rahman]

Originally Posted by mokujin

Use {vb:raw usg.amount} in your template?

oh snap!! fixed, thanks very much