I'm using this Mshah frontend user manager extension. I have below table and I want to hide the "Registered" value from that column, is that possible?
As you can see, the third column is a user group title that a user belongs to, and I want to hide the Registered value if possible.
if ($isAdmin || $groupNames=='ums') {
$query="SELECT a.*,CASE a.block WHEN 0 THEN 'Active' ELSE 'Inactive' END as status,group_concat(b.group_id) as ucheckbox,group_concat(c.title) as title,c.id as groupid from `#__users` a left join `#__user_usergroup_map` b on a.id=b.user_id left join `#__usergroups` c on b.group_id=c.id group by a.id ORDER BY a.id ASC";
$db->setQuery($query);
$rows=$db->loadObjectList();
return $rows;
}
Above is the mysql query code but I don't think can use NOT IN or <> as it is filtering the results instead.
if ($group != 'Registered') { // Display the group }