From 97b2ef8a20ed995d51f1d51bb46b52b542e03901 Mon Sep 17 00:00:00 2001 From: andres_paglayan Date: Fri, 21 Oct 2005 20:42:01 +0000 Subject: [PATCH] *** empty log message *** --- interface/patient_file/report/custom_report.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/interface/patient_file/report/custom_report.php b/interface/patient_file/report/custom_report.php index 13fdf29ee..5ea18cef1 100644 --- a/interface/patient_file/report/custom_report.php +++ b/interface/patient_file/report/custom_report.php @@ -162,7 +162,7 @@ } elseif ($val == "batchcom") { print "Patient Communication sent:
"; - $sql="SELECT concat( 'Messsage Type: ', batchcom.msg_type, ' Message Subject: ', batchcom.msg_subject, ', Sent on:', batchcom.msg_date_sent ) AS batchcom_data, batchcom.msg_text, concat( users.fname, users.lname ) AS user_name FROM `batchcom` JOIN `users` ON users.id = batchcom.sent_by WHERE batchcom.patient_id='$pid'"; + $sql="SELECT concat( 'Messsage Type: ', batchcom.msg_type, ', Message Subject: ', batchcom.msg_subject, ', Sent on:', batchcom.msg_date_sent ) AS batchcom_data, batchcom.msg_text, concat( users.fname, users.lname ) AS user_name FROM `batchcom` JOIN `users` ON users.id = batchcom.sent_by WHERE batchcom.patient_id='$pid'"; // echo $sql; $result = sqlStatement($sql); while ($row=sqlFetchArray($result)) { -- 2.11.4.GIT