<?php
require_once('headMain_ord.php');
?>
			<script type="text/javascript" language="javascript" src="../js/jquery-1.7.1.js"></script>
<script type="text/javascript" language="javascript" src="../js/scriptFile3.js"></script>


              <table width="60%" align="center" cellpadding="3" cellspacing="5">
                <tr align="center">
                  <td><form id="form1" name="form1" method="post" action="tutorialPrint.php">
                    <fieldset>
                      <legend>Generate Tutorial List</legend>
                      <table width="100%" cellspacing="5" cellpadding="3">
                        <tr>
                          <td>School</td>
                          <td>&nbsp;</td>
                          <td><select name="txtschool" id="school" class="form-control">
                 <?php


			  $query="SELECT distinct dSchool FROM dept";
				$rs=$db->query($query);
				echo '<option>'.'Select Option...'.'</option>';
                 while ($rows=$rs->fetch(PDO::FETCH_BOTH)){
				//for($i=0;$i<mysql_num_rows($rs);$i++){
				//	$row=mysql_fetch_row($rs);
					
					echo '<option>'.$rows[0].'</option>';
				}
			  ?>
                          </select></td>
                        </tr>
                        <tr>
                          <td>Department</td>
                          <td>&nbsp;</td>
                          <td id="dept">&nbsp;</td>
                        </tr>
                        <tr>
                          <td>Session</td>
                          <td>&nbsp;</td>
                          <td>
                          
  <?php                        $sql_current=$db->query("select * from current");
            $num_current=$sql_current->rowCount();
			if ($num_current>0){
                $sql_current_fetch=$sql_current->fetch(PDO::FETCH_ASSOC);
				  $semester=$_SESSION['asemester']=$sql_current_fetch['asemester'];
				echo $asession=$_SESSION['asession']=$sql_current_fetch['asession'];
				 $_SESSION['asemester'];
				 $_SESSION['asession'];
            
			}

?>
                          
                          
                          </td>
                        </tr>
                        <tr>
                          <td>Semester</td>
                          <td>&nbsp;</td>
                          <td><?php echo $semester; ?></td>
                        </tr>
                        <tr>
                          <td>Level</td>
                          <td>&nbsp;</td>
                          <td><select name="level" id="level" class="form-control">
                            <?php

			  $queryk="SELECT distinct levelName FROM leveltb";
				$rsk=$db->query($queryk);

				echo '<option>'.'Select Option...'.'</option>';

                            while($rowk=$rsk->fetch(PDO::FETCH_ASSOC)){

                           // for($i=0;$i<mysql_num_rows($rs);$i++){
					//$row=mysql_fetch_row($rs);
					
					echo '<option>'.$rowk['levelName'].'</option>';
				}
			  ?>
                          </select></td>
                        </tr>
                        <tr>
                          <td>&nbsp;</td>
                          <td>&nbsp;</td>
                          <td><input type="submit" name="button" id="button" value="Generate" /></td>
                        </tr>
                      </table>
                    </fieldset>
                  </form></td>
                </tr>
              </table><!-- InstanceEndEditable --></td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
<p>&nbsp;</p>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</body>
<!-- InstanceEnd --></html>