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