3 function tests_delete($course) {
\r
6 $sql = "SELECT test_id FROM ".TABLE_PREFIX."tests WHERE course_id=$course";
\r
7 $result = mysql_query($sql, $db);
\r
8 while ($row = mysql_fetch_assoc($result)) {
\r
9 $sql = "DELETE FROM ".TABLE_PREFIX."tests_questions_assoc WHERE test_id=$row[test_id]";
\r
10 $result2 = mysql_query($sql, $db);
\r
12 $sql2 = "SELECT result_id FROM ".TABLE_PREFIX."tests_results WHERE test_id=$row[test_id]";
\r
13 $result2 = mysql_query($sql2, $db);
\r
14 while ($row2 = mysql_fetch_assoc($result2)) {
\r
15 $sql3 = "DELETE FROM ".TABLE_PREFIX."tests_answers WHERE result_id=$row2[result_id]";
\r
16 $result3 = mysql_query($sql3, $db);
\r
18 $sql = "DELETE FROM ".TABLE_PREFIX."tests_results WHERE test_id=$row[test_id]";
\r
19 $result2 = mysql_query($sql, $db);
\r
22 $sql = "DELETE FROM ".TABLE_PREFIX."tests_questions WHERE course_id=$course";
\r
23 $result = mysql_query($sql, $db);
\r
25 $sql = "DELETE FROM ".TABLE_PREFIX."tests_questions_categories WHERE course_id=$course";
\r
26 $result = mysql_query($sql, $db);
\r
28 $sql = "DELETE FROM ".TABLE_PREFIX."tests WHERE course_id=$course";
\r
29 $result = mysql_query($sql, $db);
\r