From cc30e024e787dedc1c4251008c8b7b2372637fb9 Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Sun, 23 May 2021 23:33:06 +0530
Subject: [PATCH] Sorted medicines

---
 lib/db.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/db.php b/lib/db.php
index 8a02ae5..f0f0489 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -250,7 +250,7 @@ class DB extends SQLite3 {
   function getDrugs($pid){
     global $log;
     if(!checkAccess("treatment", "dbGet")) return false;
-    $stmt=$this->prepare("SELECT rowid,* FROM treatment WHERE pid=:pid;");
+    $stmt=$this->prepare("SELECT rowid,* FROM treatment WHERE pid=:pid ORDER BY omit,start;");
     $stmt->bindValue(":pid", $pid);
     $result=$stmt->execute();
     return($result);
-- 
2.39.5