Minor

diff --git a/lib/db.php b/lib/db.php
index c6cdde3cb9a8a6c3ea26736ea6e5c0f2668cdaaa..1cfdb5aa8ba00e9a7803aac8f2461b649496f20a 100644 (file)
--- a/lib/db.php
+++ b/lib/db.php
@@ -271,7 +271,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 AND omit!=:omit ORDER BY omit,start;");
+    $stmt=$this->prepare("SELECT rowid,* FROM treatment WHERE pid=:pid AND omit!=:omit ORDER BY omit,drug,start;");
     $stmt->bindValue(":pid", $pid);
     $stmt->bindValue(":omit", -1);
     $result=$stmt->execute();