From e9f2c65e4da44066cf3af72622127eaf2ea61909 Mon Sep 17 00:00:00 2001
From: Alexander Schmidt <alex@treefish.org>
Date: Mon, 8 Oct 2012 15:42:20 +0200
Subject: [PATCH] ...

---
 admin/blackboard.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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)) {
-- 
2.39.2