format("Y-m-d"); $toTime =date('H:i:s'); $dateTime = $myDate . " ".$toTime; $myEmpID = $user_data['u_id']; //echo $myEmpID; $chkDeferred = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id` ='$compID' AND `cl_h_hr_approval`='DEFERRED'"),0); //$myCheckCreation = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id` ='$compID' AND `cl_h_hr_approval`='LAST PAY COMPUTATION'"),0); echo $chkDeferred; ?>