<?php
 
$host='localhost';
	$user='root';
	$pass='';
 
	//establish database connection
	$conn=mysql_connect($host,$user,$pass) OR die('Unable to connect');
 
	//SELECT database for USE
    mysql_select_db('acumenchain') OR die('Unable to select database!');
 
 
	    $query2 = "SELECT tblclasslist.studentNo 
					FROM acumenchain.tblclasslist 
					JOIN acumenchain.tblregistration 
					ON tblclasslist.studentNo = tblclasslist.studentNo";
 
		$result = mysql_query($query2) OR die('Unable to execute Query' . mysql_error());
        $num = mysql_num_rows($result);
 
 
	//close connection
    mysql_close($conn);
 
?>