format("Y-m-d"); $toTime =date('H:i:s'); $dateTime = $myDate . " ".$toTime; $myEmpID = $user_data['u_id']; //echo $myEmpID; //$myActiveFinalPay = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='LASTPAY COMPUTATION'"),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`='CHECK CREATION'"),0); //CHECK TO CHECK ASSIGNMENT echo $myCheckCreation; ?>