X-Git-Url: https://git.treefish.org/banana.git/blobdiff_plain/7b7f10ba3917a6d5229f13d27aa4e94a9685b00e..b22b28d88c9f6d951e1008e71843436b7df42b6a:/admin/blackboard.php

diff --git a/admin/blackboard.php b/admin/blackboard.php
index 9642c59..a28d8dc 100644
--- a/admin/blackboard.php
+++ b/admin/blackboard.php
@@ -24,7 +24,7 @@
 <?php
   block("black", "blackboard overview");
 
-  $result=$db->query("SELECT firstname, lastname, mnumber, blackboard FROM students");
+  $result=$db->query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY LOWER(lastname)");
 
   print "<table>";
   while ($student = $result->fetch(PDO::FETCH_ASSOC)) {