X-Git-Url: https://git.treefish.org/banana.git/blobdiff_plain/17d5ad30f747658451fae84fe65cb1f5b66d377c..7b7f10ba3917a6d5229f13d27aa4e94a9685b00e:/admin/nextsession.php diff --git a/admin/nextsession.php b/admin/nextsession.php index f438822..ee94d50 100644 --- a/admin/nextsession.php +++ b/admin/nextsession.php @@ -6,12 +6,12 @@ if (! isset($SESSIONS_actual)) { block("red", "no next session"); - break; + exit; } block("black", "summary for session " . $SESSIONS[$SESSIONS_actual]['timestr'] . " (" . $SESSIONS[$SESSIONS_actual]['examples'] . ")"); - $result = $db->query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY lastname"); + $result = $db->query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY LOWER(lastname)"); print "
First name | Last name | Matr.nummer | Examples | Blackboard | ";