X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fsurvey%2Fsurvey.inc.php;fp=modules%2Fsurvey%2Fsurvey.inc.php;h=0c0c645ca5539b0c1758b47d5171af9e3b09e0bf;hb=ee22a54bf773690602e572529fa26c30917ba5c2;hp=b416b28c73c6b3f43b2c32a6054557d6f522ad1a;hpb=318665ddc0a020035c5ee122724fb29dcc29359b;p=platal.git

diff --git a/modules/survey/survey.inc.php b/modules/survey/survey.inc.php
index b416b28..0c0c645 100644
--- a/modules/survey/survey.inc.php
+++ b/modules/survey/survey.inc.php
@@ -200,10 +200,9 @@ class Survey
         }
         $sql = 'SELECT v.id AS vid, a.question_id AS qid, a.answer AS answer
                   FROM survey_votes AS v
-             LEFT JOIN survey_answers AS a
-                    ON a.vote_id=v.id
+            INNER JOIN survey_answers AS a ON a.vote_id=v.id
                  WHERE v.survey_id={?}
-              ORDER BY vid ASC, qid ASC, answer ASC;';
+              ORDER BY vid ASC, qid ASC, answer ASC';
         $res = XDB::iterator($sql, $this->id); // retrieves all answers from database
         $vid = -1;
         $vid_ = 0;