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'])){ $DelActionReferenceID = mysql_escape_string($_POST['DelActionReferenceID']); $DeletedPRFReferenceNumber = mysql_result(mysql_query("SELECT header_ref_code FROM prf_request_detl WHERE id='$DelActionReferenceID'"),0); mysql_query("UPDATE prf_request_detl SET deleted = 1 WHERE id='$DelActionReferenceID'"); } ?> "; echo ""; echo "Rec.#"; echo "REF. #"; echo "ITEM DESCRIPTION"; echo "UoM"; echo "QUANTITY"; echo "-"; echo ""; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; ?>".$row['id'].""; echo "".strtoupper($row['header_ref_code']).""; echo "".strtoupper($row['item_description']).""; echo "".strtoupper($row['uom']).""; echo "".strtoupper($row['quantity']).""; echo ""; echo ""; } echo ""; ?>