From 82749af7260bda0395dd0c6f1618dfacce5f5044 Mon Sep 17 00:00:00 2001 From: toyomoyo Date: Thu, 2 Nov 2006 02:02:41 +0000 Subject: [PATCH] merged fix for MDL-7112 select distinct on text field --- lib/datalib.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/datalib.php b/lib/datalib.php index d27d93f465..e0e11364ba 100644 --- a/lib/datalib.php +++ b/lib/datalib.php @@ -409,7 +409,7 @@ function get_group_users($groupid, $sort='u.lastaccess DESC', $exceptions='', $f if (!empty($extrafield)) { $extrafield = ','.$extrafield; } - return get_records_sql("SELECT DISTINCT $fields $extrafield + return get_records_sql("SELECT $fields $extrafield FROM {$CFG->prefix}user u, {$CFG->prefix}groups_members m WHERE m.groupid = '$groupid' -- 2.39.5