usergroup in memberlist

[squawell]

i got the same error

Invalid SQL: SELECT *
FROM user,userfield
LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid
WHERE 8=8 AND
user.userid = userfield.userid
AND usergroupid NOT IN (1,3,4)
ORDER BY username ASC
LIMIT 0,30
mysql error: Column: 'usergroupid' in where clause is ambiguous

and i already replace the code with FireFly's post

any idea??

[Admin]

Originally posted by squawell
and i already replace the code with FireFly's post

No, you didn't.

[squawell]

Originally posted by FireFly

No, you didn't.

yes i'm sure!!

see my code

PHP Code:

$users=$DB_site->query("SELECT *
                          FROM user,userfield
                          LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid
                          WHERE $condition AND
                                user.userid = userfield.userid
                                ".iif($memberAllGood, " AND user.usergroupid NOT IN (1,3,4) ", "")."
                          ORDER BY $orderby $direction
                          LIMIT ".($limitlower-1).",$perpage"); 


it should be like this isn't it??

but it still cann't work~~

[Admin]

Then you didn't upload the file, because that query you pasted is not with the fix.

[ElecEagle]

Sorry to bother, but I have one quick question:

I have added this 'hack', but could someone please post what I would need to change in it to use the "user status" field for the group, rather than the group name? It's probably pretty easy ...I just don't know off hand what it would be. ...

[sgeiger]

Chen,

How could I change this query to only show members of a usergroup when one clicks on memberlist.

I want no outside groups to see the members of other user groups.

Group A to see only group A members in memberlist....
and
Group B to only see group B members in member list....

Originally Posted by Chen

Err I'm in a bit of a hurry, but try replacing this in memberlist.php:

  $users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE $condition AND

with this:

  $users=$DB_site->query("SELECT *
                          FROM user,userfield
                          LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid
                          WHERE $condition AND

then try using $user[title] in the memberlistbit template.

Hope this works.