Quote:
Originally posted by Okiewan
Any way to select with groups to display ?
|
Find:
PHP Code:
LEFT JOIN user ON (user.usergroupid = usergroup.usergroupid)
And add after it (for one group):
PHP Code:
WHERE usergroup.usergroupid='x'
Changing x to the usergroupid.
Or, For Multi groups:
PHP Code:
WHERE usergroup.usergroupid='x' or usergroup.usergroupid='x' or usergroup.usergroupid='x'
To Add/remove groups from this just add/remove:
PHP Code:
or usergroup.usergroupid='x'
Remember to change x to the usergroupid