Index: plugins/mod/questionnaire/questiontypes/questiontypes.class.php
===================================================================
RCS file: /cvsroot/moodle/contrib/plugins/mod/questionnaire/questiontypes/questiontypes.class.php,v
retrieving revision 1.31.2.23
diff -u -r1.31.2.23 questiontypes.class.php
--- plugins/mod/questionnaire/questiontypes/questiontypes.class.php	1 Nov 2008 14:14:34 -0000	1.31.2.23
+++ plugins/mod/questionnaire/questiontypes/questiontypes.class.php	17 Nov 2008 09:06:36 -0000
@@ -481,7 +481,7 @@
                        $CFG->prefix.'questionnaire_'.$this->response_table.' rt '.
                'WHERE qc.question_id='.$this->id.' AND qc.content NOT LIKE \'!other%\' AND '.
                      'rt.question_id=qc.question_id AND rt.choice_id=qc.id'.$ridstr.' '.
-               'GROUP BY qc.id,qc.content';
+               'GROUP BY qc.id,qc.content ORDER BY qc.id';
 
         $rows = get_records_sql($sql);
 
@@ -490,7 +490,7 @@
                'FROM '.$CFG->prefix.'questionnaire_response_other rt, '.
                        $CFG->prefix.'questionnaire_quest_choice qc '.
                'WHERE rt.question_id='.$this->id.' AND rt.choice_id=qc.id'.$ridstr.' '.
-               ' GROUP BY rt.response,qc.content ';
+               ' GROUP BY rt.response,qc.content,qc.id ORDER BY qc.id';
 
         if ($recs = get_records_sql($sql)) {
             $i = 1;