From 412f7c3071696dff04d4aaa664be2ad636151ce5 Mon Sep 17 00:00:00 2001 From: yehster Date: Mon, 24 Oct 2011 13:34:58 -0400 Subject: [PATCH] Addressing SQL syntax issue in messages.php --- interface/main/messages/messages.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/interface/main/messages/messages.php b/interface/main/messages/messages.php index d68055ec5..533c8029b 100644 --- a/interface/main/messages/messages.php +++ b/interface/main/messages/messages.php @@ -400,7 +400,7 @@ else { FROM ((pnotes LEFT JOIN users ON pnotes.user = users.username) JOIN patient_data ON pnotes.pid = patient_data.pid) WHERE pnotes.message_status != 'Done' AND pnotes.deleted != '1' AND pnotes.assigned_to LIKE ?". - "order by ".add_escape_custom($sortby)." ".add_escape_custom($sortorder). + " order by ".add_escape_custom($sortby)." ".add_escape_custom($sortorder). " limit ".add_escape_custom($begin).", ".add_escape_custom($listnumber); $result = sqlStatement($sql, array($usrvar) ); while ($myrow = sqlFetchArray($result)) { -- 2.11.4.GIT