Count Male/Female Specific Usergroup

[Niki]

Placed it at the third and still receiving errors.

PHP Code:

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

---

Also tried

PHP Code:

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

---