<?php 



$host = 'localhost';



$username = 'mdsoftwareco_rns';



$password = 'w&S8zzGMx]QI';



$database = 'mdsoftwareco_rns';



$dbconfig = mysql_connect($host,$username,$password,$database);







$db=mdsoftwareco_rns;



$link;



$link = mysql_connect( "localhost", "mdsoftwareco_rns", "w&S8zzGMx]QI" );



if ( ! $link )



die( "Couldn't connect to MySQL" );



mysql_select_db( $db, $link )



or die ( "Couldn't open iet: ".mysql_error() );$counter=$_GET['counter'];



$vdate=$_GET['vdate'];



$counter=$_GET['counter'];

$course_name=$_GET['course_name'];

$Course_Details=$_GET['Course_Details'];

//echo $class2."/".$catag."/".$reservation;



//if($counter!='admin'){

//

//$checkui="select * from fverify where vdate LIKE '%$vdate%' and counter='$counter' ORDER BY class";

//

//}else{



$checkui="select * from fverify where vdate LIKE '%$vdate%' and session='$session' and code='$code' ORDER BY class";



//}



$runui=mysql_query($checkui);







$totalui=mysql_num_rows($runui);











//$row_challanui = mysql_fetch_array($runui, MYSQL_BOTH);



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



?>







       



        <table width="100%" cellspacing="0" cellpadding="0" border="1">



 



   



  <tr>



    <td><div align="center"><strong>Sr. No</strong></div></td>



    <td>Date</td>
    <td><div align="center"><strong>College Roll Number</strong></div></td>



    



    <td><div align="center"><strong>Register Roll Number</strong></div></td>



    <td><div align="center"><strong>Examination Form Number</strong></div></td>



    <td><div align="center"><strong>Student Name</strong></div></td>



     



    



    <td><div align="center"><strong>Father Name</strong></div></td>



    <td><strong>Gender</strong></td>



    <td><strong>Class</strong></td>



  



   



    <td><div align="center"><strong>Subject</strong></div></td>



   



   <td>Counter</td>
  </tr>



    



  <?php 



  $a=1;



while ( $a_row = mysql_fetch_array($runui, MYSQL_BOTH) )







 	{



	$rollno=$a_row['croll_on'];



	$user_name=$a_row['user_name'];

 $check_exist_qry1="select * from class2 where college_roll='$rollno' and pay_fee!='' and checked_by!='' and session='$session' and code='$code'";

$run_qry1=mysql_query($check_exist_qry1);

$total_found1=mysql_num_rows($run_qry1);

$roww = mysql_fetch_array($run_qry1);

if(($course_name!="")&&($Course_Details!="")){

$college_type=$roww['CourseType'];

$course_type=$roww['Course'];

$sem_yer=$roww['Course_Details'];

$roll_no=$roww['college_roll'];

}

$code=$roww['college'];

$college_typee=$roww['CourseType'];

$course_typee=$roww['Course'];

$sem_yerr=$roww['Course_Details'];

$queryy = "SELECT * FROM course_name where college_id='$code' && id='$course_typee' and session='$session' and code='$code'";

$numresultsy=mysql_query($queryy);

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

$a_rowwx = mysql_fetch_array( $resulty );

 //echo $course_type.'-'.$sem_yer;

if(($course_name==$course_type)&&($Course_Details==$sem_yer)){

	







		?>



  <tr>



    <td><div align="center"><?php echo $a; ?></div></td>



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



     



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



    <td><div align="center"><?php echo $a_row['ex_form_no']; ?></div></td>



    <td><div align="left"><?php echo $a_row['sname']; ?></div></td>



     



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



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



     <td><?php

echo $a_rowwx['course_name'];?>-

<?php

 echo $sem_yerr; ?>  -  Year</td>



    



  



    <td><div align="left"><?php 



	$class_app=$a_row['class_app_list_new'];



	



	



	echo $class_app; ?></div></td>



    



   <td><div align="left"><?php echo $a_row['counter']; ?></div></td>
  </tr>



 











        



        



        <?php $a=$a+1;}} ?>
</table>



</div>







<!-- /#page-wrapper -->















    </div>







    <!-- /#wrapper -->















    <!-- jQuery -->







    <script src="js/jquery.js"></script>















    <!-- Bootstrap Core JavaScript -->







    <script src="js/bootstrap.min.js"></script>

















    <!-- Morris Charts JavaScript -->







    <script src="js/plugins/morris/raphael.min.js"></script>







    <script src="js/plugins/morris/morris.min.js"></script>







    <script src="js/plugins/morris/morris-data.js"></script>















</body>















</html>