format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $selectedPRFHeaderID = mysql_escape_string($_POST['selectedPRFHeaderID']); mysql_query("UPDATE prf_request_hdr SET deleted = 1 WHERE reference_code='$selectedPRFHeaderID'"); mysql_query("UPDATE prf_request_detl SET deleted = 1 WHERE header_ref_code='$selectedPRFHeaderID'"); } ?>
NO REF. CODE DATE COMPANY DEALER REQ. CATEGOY REQ. TYPE APPROVED BY STATUS
".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
".strtoupper($row['reference_code'])."".strtoupper($row['date_created'])."".strtoupper($prfCompName)."".strtoupper($prfDealName)."".strtoupper($prfCatName)."".strtoupper($prfSubCatName)."".strtoupper($prfDeptApproverLName).", ".strtoupper($prfDeptApproverFName).""; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = '$status'"),0); echo $statusName; echo"
Selected Record: