http://www.atutor.ca/atutor/mantis/view.php?id=4475

Fix a mysql error at "add questions" to a test

diff --git a/docs/tests/html/tests_questions.inc.php b/docs/tests/html/tests_questions.inc.php
index 18fd420..3454e8a 100644 (file)
--- a/docs/tests/html/tests_questions.inc.php
+++ b/docs/tests/html/tests_questions.inc.php
@@ -44,7 +44,7 @@ if ($_GET['category_id'] <= 0) {
 if (is_array($category_rows)) {\r
        foreach ($category_rows as $row) $cats[] = $row;\r
 }\r
-else if (isset($category_row)) {\r
+else if (isset($category_row) && $category_row <> '') {\r
        $cats[] = $category_row;\r
 }\r
 \r
@@ -118,11 +118,7 @@ $question_flag = FALSE;
 //output categories\r
 foreach ($cats as $cat) {\r
        //ouput questions\r
-//     $sql    = "SELECT * FROM ".TABLE_PREFIX."tests_questions WHERE course_id=$_SESSION[course_id] AND category_id=".$cat['category_id']." ORDER BY question";\r
-//     $result = mysql_query($sql, $db);\r
-//     if ($row = mysql_fetch_assoc($result)) {\r
        $rows = $testsQuestionsDAO->getByCourseIDAndCategoryID($_course_id, $cat['category_id']);\r
-//     debug($cat);debug($rows);\r
        if (is_array($rows)) {\r
                $question_flag = TRUE;\r
                echo '<tr>';\r