Sorted patient list

diff --git a/lib/db.php b/lib/db.php
index 84c260532902120cf9d058cff2f3d2ddac90cb84..428286dcc8684e748acc53c5b64910a475a19cf4 100644 (file)
--- a/lib/db.php
+++ b/lib/db.php
@@ -357,14 +357,14 @@ class DB extends SQLite3 {
   function getPatientList(){
     global $log;
     if(!checkAccess("info", "dbGet")) return false;
-    $stmt=$this->prepare("SELECT pid,ward,bed,name,diagnosis,status FROM patients ORDER BY ward,bed;");
+    $stmt=$this->prepare("SELECT pid,ward,bed,name,diagnosis,status FROM patients ORDER BY pid;");
     $result=$stmt->execute();
     return($result);
   }
   function getAdmittedPatientList(){
     global $log;
     if(!checkAccess("info", "dbGet")) return false;
-    $stmt=$this->prepare("SELECT pid,ward,bed,name,diagnosis FROM patients WHERE status='admitted';");
+    $stmt=$this->prepare("SELECT pid,ward,bed,name,diagnosis FROM patients WHERE status='admitted' ORDER BY ward,bed;");
     $result=$stmt->execute();
     return($result);
   }