3 function groups_delete($course) {
\r
6 $sql = "SELECT G.group_id FROM ".TABLE_PREFIX."groups G INNER JOIN ".TABLE_PREFIX."groups_types T USING (type_id) WHERE T.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."groups_members WHERE group_id=$row[group_id]";
\r
10 $result2 = mysql_query($sql, $db);
\r
12 $sql = "DELETE FROM ".TABLE_PREFIX."tests_groups WHERE group_id=$row[group_id]";
\r
13 $result2 = mysql_query($sql, $db);
\r
15 $sql = "DELETE FROM ".TABLE_PREFIX."groups WHERE group_id=$row[group_id]";
\r
16 $result2 = mysql_query($sql, $db);
\r
19 $sql = "DELETE FROM ".TABLE_PREFIX."groups_types WHERE course_id=$course";
\r
20 $result = mysql_query($sql, $db);
\r
22 // -- remove assoc between tests and groups:
\r