format("Y-m-d"); $toTime =date('H:i:s'); $dateTime = $myDate . " ".$toTime; $myEmpID = $user_data['u_id']; //echo $myEmpID; $myActiveReleasePay = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_emp_id` ='$comID' AND `cl_h_hr_approval`='FOR RELEASE'"),0); echo $myActiveReleasePay; ?>