Count Male/Female Specific Usergroup

[RateU]

If there are more than one conditions, you should use AND or OR, not ,

For example (based on your query):

PHP Code:

// Usergroup Number Counts $num_male = $db->fetch_field($db->simple_select("userfields", "COUNT(ufid) as count", "usergroup IN ('4') AND fid3='Male'"), "count"); $num_female = $db->fetch_field($db->simple_select("userfields", "COUNT(ufid) as count", "usergroup IN ('4') AND fid3='Female'"), "count");

---