$xml_string .= "<reason>ERROR: Sorry, there was an error processing your data. Please re-submit the information again.</reason>\n";
            }
        } else {
            $strQuery = "select l.* from lists as l\n                        LEFT JOIN `issue_encounter` as i ON i.list_id = l.id\n                        where l.pid=?  order by l.date DESC";
            $result = sqlStatement($strQuery, array($pid));
            if ($result->_numOfRows > 0) {
                $xml_string .= "<status>0</status>\n";
                $xml_string .= "<reason>The Patient Record has been fetched</reason>\n";
                $count = 0;
                while ($res = sqlFetchArray($result)) {
                    $xml_string .= "<listitem>\n";
                    foreach ($res as $fieldName => $fieldValue) {
                        $rowValue = xmlsafestring($fieldValue);
                        $xml_string .= "<{$fieldName}>{$rowValue}</{$fieldName}>\n";
                    }
                    $diagnosis_title = getDrugTitle($list[$i]->diagnosis, $db);
                    $xml_string .= "<diagnosistitle>{$diagnosis_title}</diagnosistitle>";
                    $xml_string .= "</listitem>\n";
                }
            } else {
                $xml_string .= "<status>-1</status>\n";
                $xml_string .= "<reason>ERROR: Sorry, there was an error processing your data. Please re-submit the information again.</reason>\n";
            }
        }
    } else {
        $xml_string .= "<status>-2</status>\n";
        $xml_string .= "<reason>You are not Authorized to perform this action</reason>\n";
    }
} else {
    $xml_string .= "<status>-2</status>\n";
    $xml_string .= "<reason>Invalid Token</reason>\n";
     $xml_array['Patient']['dentallist']['status'] = 0;
     foreach ($list_data_d as $key => $list_data1_d) {
         $xml_array['Patient']['dentallist']['dental-' . $key] = $list_data1_d;
         $diagnosis_title = getDrugTitle($list_data1_d['diagnosis'], $db);
         $xml_array['Patient']['dentallist']['dental-' . $key]['diagnosis_title'] = $diagnosis_title;
     }
 } else {
     $xml_array['Patient']['dentallist']['status'] = 1;
     $xml_array['Patient']['dentallist']['reason'] = 'No Dental data found';
 }
 $list_data_s = getListByType($p_id, 'surgery');
 if ($list_data_s) {
     $xml_array['Patient']['surgerylist']['status'] = 0;
     foreach ($list_data_s as $key => $list_data1_s) {
         $xml_array['Patient']['surgerylist']['surgery-' . $key] = $list_data1_s;
         $diagnosis_title = getDrugTitle($list_data1_s['diagnosis'], $db);
         $xml_array['Patient']['surgerylist']['surgery-' . $key]['diagnosis_title'] = $diagnosis_title;
     }
 } else {
     $xml_array['Patient']['surgerylist']['status'] = 1;
     $xml_array['Patient']['surgerylist']['reason'] = 'No surgery data found';
 }
 $patient_data = getPatientNotes($p_id);
 if ($patient_data) {
     $xml_array['Patient']['notelist']['status'] = 0;
     foreach ($patient_data as $key => $patient_data_a) {
         $xml_array['Patient']['notelist']['note-' . $key] = $patient_data_a;
     }
 } else {
     $xml_array['Patient']['notelist']['status'] = 1;
     $xml_array['Patient']['notelist']['reason'] = 'No Patient Data found';
                $xml_string .= "<reason>ERROR: Sorry, there was an error processing your data. Please re-submit the information again.</reason>\n";
            }
        } else {
            $strQuery = "select l.* from lists as l\n                        LEFT JOIN `issue_encounter` as i ON i.list_id = l.id\n                        where l.pid=?  order by l.date DESC";
            $result = sqlStatement($strQuery, array($pid));
            if ($result->_numOfRows > 0) {
                $xml_string .= "<status>0</status>\n";
                $xml_string .= "<reason>The Patient Record has been fetched</reason>\n";
                $count = 0;
                while ($res = sqlFetchArray($result)) {
                    $xml_string .= "<listitem>\n";
                    foreach ($res as $fieldName => $fieldValue) {
                        $rowValue = xmlsafestring($fieldValue);
                        $xml_string .= "<{$fieldName}>{$rowValue}</{$fieldName}>\n";
                    }
                    $diagnosis_title = getDrugTitle($res['diagnosis'], $db);
                    $xml_string .= "<diagnosistitle>{$diagnosis_title}</diagnosistitle>";
                    $xml_string .= "</listitem>\n";
                }
            } else {
                $xml_string .= "<status>-1</status>\n";
                $xml_string .= "<reason>ERROR: Sorry, there was an error processing your data. Please re-submit the information again.</reason>\n";
            }
        }
    } else {
        $xml_string .= "<status>-2</status>\n";
        $xml_string .= "<reason>You are not Authorized to perform this action</reason>\n";
    }
} else {
    $xml_string .= "<status>-2</status>\n";
    $xml_string .= "<reason>Invalid Token</reason>\n";