From 734d2c988764641f324302df409ccce4032999a4 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Mon, 17 Feb 2003 08:35:51 +0000
Subject: [PATCH] Fixes to survey_get_responses() to make it work better with
 PostgreSQL (from Petri Asikainen)

---
 mod/survey/lib.php | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

diff --git a/mod/survey/lib.php b/mod/survey/lib.php
index eb2f223b0b..4357c8967d 100644
--- a/mod/survey/lib.php
+++ b/mod/survey/lib.php
@@ -145,14 +145,16 @@ function survey_log_info($log) {
 
 function survey_get_responses($survey) {
     global $CFG;
-    return get_records_sql("SELECT a.time as time, count(*) as numanswers, u.*
+    return get_records_sql("SELECT MAX(a.time) as time, 
+                                   count(*) as numanswers, 
+                                   u.id, u.firstname, u.lastname
                               FROM {$CFG->prefix}survey_answers AS a, 
                                    {$CFG->prefix}user AS u
                              WHERE a.answer1 <> '0' AND a.answer2 <> '0'
                                    AND a.survey = $survey 
                                    AND a.userid = u.id
-                          GROUP BY a.userid 
-                          ORDER BY a.time ASC");
+                          GROUP BY u.id, u.firstname, u.lastname
+                          ORDER BY time ASC");
 }
 
 function survey_get_analysis($survey, $user) {
-- 
2.39.5