<?php
include 'core/init.php';
//$connect_error = 'Sorry, we\'re experiencing connection problem.  Please try again later...  Thank you!';
//mysql_connect('localhost','root','aee1024') or die ($connect_error);
//mysql_select_db('db_vts') or die($connect_error);
error_reporting(0);
$compID= $user_data['company'];
$myDate = date_create() ->format("Y-m-d"); 
$toTime =date('H:i:s');
$dateTime = $myDate . " ".$toTime;
$myEmpID = $user_data['u_id'];
//echo $myEmpID;
$myActiveClearance = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_emp_id` ='$myEmpID' AND `cl_h_hr_approval`!='CLOSED'"),0);
 
echo $myActiveClearance;
?>