Database query to list all users within usergroup?

[Ua|Eight]

If I wanted to export a list of users in usergroup id = 44, how would I go about that?

[ForceHSS]

Export them to where?

[ozzy47]

You can do that from phpmyadmin within your cpanel, by running this query:

SELECT * FROM user
WHERE usergroupid = 44

You can then export the list from there.

[Simon Lloyd]

Originally Posted by ozzy47

You can do that from phpmyadmin within your cpanel, by running this query:

SELECT * FROM user
WHERE usergroupid = 44

You can then export the list from there.

You can run that directly in admincp>maintainance>execute sql query and you'll get a list (don't forget to add any table prefix you use before "user" so maybe you use vb as the prefix and it would look like this

PHP Code:

SELECT * FROM vb_user
WHERE usergroupid = 44 


[ozzy47]

Originally Posted by Simon Lloyd

You can run that directly in admincp>maintainance>execute sql query and you'll get a list (don't forget to add any table prefix you use before "user" so maybe you use vb as the prefix and it would look like this

PHP Code:

SELECT * FROM vb_user
WHERE usergroupid = 44 


Right, but he won't be able to export it as he asked in the OP.

[Simon Lloyd]

Doh, should read more carefully

[ozzy47]

It happens to all of us at some point.

[Simon Lloyd]

This should help you export the results to csv http://www.tech-recipes.com/rx/1475/...t-or-csv-file/