From fd2cc0d700e601caf3af8c98156f036ffec697f4 Mon Sep 17 00:00:00 2001 From: plegall Date: Fri, 6 May 2005 20:48:52 +0000 Subject: - bug fixed : users belonging to several groups were shown several times git-svn-id: http://piwigo.org/svn/trunk@786 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/user_list.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/admin/user_list.php b/admin/user_list.php index 615ecdf58..c53a39220 100644 --- a/admin/user_list.php +++ b/admin/user_list.php @@ -278,7 +278,7 @@ if (isset($_GET['direction']) } $query = ' -SELECT id, username, mail_address, status +SELECT DISTINCT(id), username, mail_address, status FROM '.USERS_TABLE.' LEFT JOIN '.USER_GROUP_TABLE.' ON id = user_id WHERE id != 2'; if (isset($filter['username'])) -- cgit v1.2.3