<?php
session_start();
 $subject1=$_POST['subject1'];
$deptid=$_SESSION['deptID'] ;
$casse=$_POST['casse'];
//echo $school;
//die();
require('../connect.php');
$db=db_connect();

if ($casse==1) {
				$query="select distinct OlevelCourse_ID, subject from vwolevelrequirement where Dept_ID=$deptid and OlevelCourse_ID<>$subject1 and (ID not in (select ID from vwolevelrequirement where Dept_ID=$deptid and NumRequired=1 and Group1 in (select Group1 from vwolevelrequirement where  OlevelCourse_ID=$subject1  and Dept_ID=$deptid  ))) and (ID not in (select ID  from  vwolevelrequirement  where Dept_ID=$deptid and NumRequired_Childgroup=1 and Child_Group in (select Child_Group from vwolevelrequirement where OlevelCourse_ID=$subject1 and Dept_ID=$deptid )))";
				$rs=$db->query($query);
				$out='<select name="sel2" id="select2" class="form-control">';
				while($row=$rs->fetch(PDO::FETCH_BOTH)){
					$out.= '<option value="' .$row['OlevelCourse_ID']. '">' .$row['subject'].' </option>';
				}
				$out.='</select>';
				$out.='<script type="text/javascript" language="JavaScript" src="../js/jquery-1.7.1.js"></script>
            <script type="text/javascript" language="JavaScript" src="../js/scriptFile2.js"></script>';
				echo $out;
				}
				
				
				
				
elseif ($casse=2){
	            $subject2=$_POST['subject2'];
				$query="select distinct OlevelCourse_ID, subject from vwolevelrequirement where Dept_ID=$deptid and OlevelCourse_ID not in ($subject1,$subject2) and (ID not in (select ID from  vwolevelrequirement where Dept_ID=$deptid and NumRequired=2 and Group1 =(select Group1 from vwolevelrequirement where  OlevelCourse_ID=$subject1 and Dept_ID=$deptid limit 1) and Group1 = (select Group1 from vwolevelrequirement where  OlevelCourse_ID=$subject2 and Dept_ID=$deptid limit 1))) and (ID not in (select ID from vwolevelrequirement where Dept_ID=$deptid and NumRequired=1 and Group1 in (select Group1 from vwolevelrequirement where (OlevelCourse_ID=$subject1 or OlevelCourse_ID=$subject2 ) and Dept_ID=$deptid))) and (ID not in (select ID from vwolevelrequirement where Dept_ID=$deptid and NumRequired_Childgroup=1 and Child_Group in (select Child_Group from vwolevelrequirement where (OlevelCourse_ID=$subject1 or OlevelCourse_ID= $subject2) and Dept_ID=$deptid )))";
				$rs=$db->query($query);
				$out='<select name="sel3" id="select3" class="form-control">';
				while($row=$rs->fetch(PDO::FETCH_BOTH)){
					$out.= '<option value="' .$row['OlevelCourse_ID']. '">' .$row['subject'].'                    </option>';
				}
				$out.='</select>';
				$out.='<script type="text/javascript" language="JavaScript" src="../js/jquery-1.7.1.js"></script>
            <script type="text/javascript" language="JavaScript" src="../js/scriptFile2.js"></script>';
				echo $out;
	
	
	
	///*$query="select distinct OlevelCourse_ID, subject from vwolevelrequirement  where Dept_ID=$deptid and                OlevelCourse_ID not in ($subject1,$subject2)  and  (ID not in (select ID from  vwolevelrequirement  where Dept_ID=$deptid and  NumRequired=2 and Group1 in (select Group1 from vwolevelrequirement where  OlevelCourse_ID=$subject1  and  Dept_ID=$deptid  ) and Group1 in (select Group1 from vwolevelrequirement where  OlevelCourse_ID=$subject2  and  Dept_ID=$deptid  ))) and  (ID not in (select ID from  vwolevelrequirement  where Dept_ID=$deptid and                NumRequired=1 and Group1 in (select Group1 from vwolevelrequirement where  (OlevelCourse_ID=$subject1 or OlevelCourse_ID=$subject2 )  and                Dept_ID=$deptid  )))   and (ID not in (select ID  from  vwolevelrequirement  where Dept_ID=$deptid and                NumRequired_Childgroup=1 and Child_Group in (select Child_Group from vwolevelrequirement where  (OlevelCourse_ID=$subject1 or OlevelCourse_ID= $subject2) and  Dept_ID=$deptid )))  ";*/
	
	}
?>