include('../includes/dbconnect.inc'); //contains the function that makes connection to mysql
$connection = db_connect(); //connecting to mysql server
echo "
";
echo"
";
$Campus_Select = "select * from news where Category = 'Campus'";
$Campus_Result = mysql_db_query($database_name, $Campus_Select);
$num_Campus = mysql_num_rows($Campus_Result);
$Course_Select = "select * from news where Category = 'Course'";
$Course_Result = mysql_db_query($database_name, $Course_Select);
$num_Course = mysql_num_rows($Course_Result);
$Subject_Select = "select * from news where Category = 'Subject'";
$Subject_Result = mysql_db_query($database_name, $Subject_Select);
$num_Subject = mysql_num_rows($Subject_Result);
echo"";
?>