]> git.treefish.org Git - banana.git/commitdiff
...
authorAlexander Schmidt <alex@treefish.org>
Mon, 8 Oct 2012 13:42:20 +0000 (15:42 +0200)
committerAlexander Schmidt <alex@treefish.org>
Mon, 8 Oct 2012 13:42:20 +0000 (15:42 +0200)
admin/blackboard.php

index 9642c591e6d59f3fad0360a184c4e92ebdc91773..a28d8dc69cb250fbfd8a729c0d519111410b0405 100644 (file)
@@ -24,7 +24,7 @@
 <?php
   block("black", "blackboard overview");
 
 <?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)) {
 
   print "<table>";
   while ($student = $result->fetch(PDO::FETCH_ASSOC)) {