Count Male/Female Specific Usergroup

[RateU]

Yeah, because the usergroup is in users table. You need to join userfields table with users table.

Something like this:

PHP Code:

1 2 3 4 5 6 7 8

$NumMale = $db->fetch_field( $db->query(' SELECT COUNT(*) AS NumMale FROM '.TABLE_PREFIX.'users u LEFT JOIN '.TABLE_PREFIX.'userfields uf ON (u.uid=uf.ufid) WHERE u.usergroup=2 AND uf.fid3="Male" '),'NumMale' );

---