Index: mod/survey/lib.php
===================================================================
RCS file: /cvsroot/moodle/moodle/mod/survey/lib.php,v
retrieving revision 1.63.2.3
diff -c -r1.63.2.3 lib.php
*** mod/survey/lib.php	24 Jan 2008 20:29:37 -0000	1.63.2.3
--- mod/survey/lib.php	4 May 2008 22:30:39 -0000
***************
*** 153,165 ****
  
      $slist = implode(',', $ids); // there should not be hundreds of glossaries in one course, right?
  
!     if (!$rs = get_recordset_sql("SELECT sa.userid, sa.survey, sa.time,
                                           u.firstname, u.lastname, u.email, u.picture
                                      FROM {$CFG->prefix}survey_answers sa
                                           JOIN {$CFG->prefix}user u ON u.id = sa.userid
                                     WHERE sa.survey IN ($slist) AND sa.time > $timestart
!                                 GROUP BY sa.userid, sa.survey
!                                 ORDER BY sa.id ASC")) {
          return false;
      }
  
--- 153,165 ----
  
      $slist = implode(',', $ids); // there should not be hundreds of glossaries in one course, right?
  
!     if (!$rs = get_recordset_sql("SELECT sa.userid, sa.survey, MAX(sa.time) AS time,
                                           u.firstname, u.lastname, u.email, u.picture
                                      FROM {$CFG->prefix}survey_answers sa
                                           JOIN {$CFG->prefix}user u ON u.id = sa.userid
                                     WHERE sa.survey IN ($slist) AND sa.time > $timestart
!                                    GROUP BY sa.userid, sa.survey, u.firstname, u.lastname, u.email, u.picture
!                                    ORDER BY time ASC")) {
          return false;
      }