<?php include "header_with_out_nav.php";



if($login_type!=''){

$issuedate=$_GET['issuedate'];

$code=$_GET['code'];

$college_type=$_GET['college_type'];

$sem_yer=$_GET['sem_yer'];

$course_type=$_GET['course_type'];

?>



 </Br></Br></Br></Br>

<table width="100%" border="1" cellspacing="2" cellpadding="2" class="table table-bordered table-striped">

  <tr>

    <td bgcolor="#000000"><span class="style3">S.No.</span></td>

    <td bgcolor="#000000"><span class="style3">Issue Date</span></td>

    <td bgcolor="#000000"><span class="style3">Course Type</span></td>

    <td bgcolor="#000000"><span class="style3">Roll No</span></td>

    <td bgcolor="#000000"><span class="style3">Student Name</span></td>

    <td bgcolor="#000000"><span class="style3">Fathers Name</span></td>

    <td bgcolor="#000000"><span class="style3">Mothers Name</span></td>

    <td bgcolor="#000000"><span class="style3">Checked By</span></td>

  </tr>

<?php

$query = "SELECT * FROM id_card WHERE code='$code' and college_type='$college_type' and `course_type`='$course_type' and sem_yer='$sem_yer' and  issuedate LIKE '%$issuedate%%' and session='$session' and code='$code' order by id";

$numresults=mysql_query($query);

 $numrows=mysql_num_rows($numresults);

$result = mysql_query($query) or die("Couldn't execute query");

//}elseif(($course_type!="")&&($login_session!='admin')){

//	 

//$query = "SELECT * FROM id_card WHERE code='$code' and college_type='$college_type' and `course_type`='$course_type' and sem_yer='$sem_yer' and  issuedate LIKE '%$txt_dob%%' and checked_by='$login_session' order by id";

//$numresults=mysql_query($query);

// $numrows=mysql_num_rows($numresults);

//$result = mysql_query($query) or die("Couldn't execute query");

//}elseif($login_type=='admin'){

//$query = "SELECT * FROM id_card WHERE code='$code' and  issuedate LIKE '%$txt_dob%%' order by checked_by";

//$numresults=mysql_query($query);

// $numrows=mysql_num_rows($numresults);

//$result = mysql_query($query) or die("Couldn't execute query");

//}elseif($login_session!='admin'){

//$query = "SELECT * FROM id_card WHERE code='$code' and  issuedate LIKE '%$txt_dob%%' and checked_by='$login_session' order by id";

//$numresults=mysql_query($query);

// $numrows=mysql_num_rows($numresults);

//$result = mysql_query($query) or die("Couldn't execute query");

//}



?>

<?php 

$counter = 1;?>

 <?php

while ( $a_row = mysql_fetch_array( $result ) )

 {?>

  <tr>

    <td><?php echo $counter; ?></td>

    <td><?php echo $a_row['issuedate']; ?></td>

    <td><?php echo $a_row['college_type']; ?></td>

    <td><?php echo $a_row['rollno']; ?></td>

    

    <td><?php

	$roll_no=$a_row['rollno'];

	$queryy = "SELECT * FROM class2 where college_roll='$roll_no' and session='$session' and code='$code'";

$numresultsy=mysql_query($queryy);

$resulty= mysql_query($queryy) or die("Couldn't execute query");

$a_rowop = mysql_fetch_array($resulty );

	

	 echo $a_rowop['StudentName']; ?></td>

    <td><?php echo $a_rowop['FatherName']; ?></td>

    <td><?php echo $a_rowop['MotherName']; ?></td>

    

    <td><?php echo $a_row['checked_by']; ?></td>

  </tr>

  

  

  <?php $counter++;

  } ?>

</table>









<?php  }

include "footer.php"; ?>