Sql queries

[Thanatos]

I'm trying to write 2 queries and a bit of php with them.

One query which will pull a count of the members in a certain membergroup (not usergroup) and another which will pull the information in the user and userfield tables, again, based on membergroup.

can someone give me a hand figuring this out please?

[filburt1]

If it's not an addon usergroup,

SELECT usergroupid, COUNT(userid) AS membershipcount FROM user GROUP BY usergroupid
If it's an addon usergroup (a "membergroup", as you say, I guess), it requires PHP handling to explode the membergroupids and use in_array() to find hits.

[Thanatos]

so if I understand correctly, if it is a membergroupid (from the user table in vb) I have to set up an array first in order to extract a specific group out of it?