Total Users In Usergroup

[kh99]

Oops, I left out the part where you set $num_grp_members (I think I originally posted it like that then edited the post to fix it). Also, you should use <br /> instead of \n. So, try this:

PHP Code:

global $vbulletin;
if ($result = $vbulletin->db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE usergroupid = 12"))
{
$output =  "We currently have " . $result['count'] . "<br /><a href=http://www.mysite.com/forum/payments.php> Upgrade now</a>";

return $output; 
} 


[Davey-UK]

Woop! Fantastic, that works a treat! I was editing my last post to include <br /> as you must have been typing this. LOL
Thankyou so much for this swift answering, its fab. Now for some styling.
Thanks again

[Davey-UK]

You wouldnt know how to fetch the last paid member username, or even the last 3, and place it in the sidebar with this bit of code would you?
Thanks