added exams

[banana.git] / admin / blackboard.php

diff --git a/admin/blackboard.php b/admin/blackboard.php
index 9642c591e6d59f3fad0360a184c4e92ebdc91773..6571f3928b24c2711bf45e49c9af4de8ddd8bcb0 100644 (file)
--- a/admin/blackboard.php
+++ b/admin/blackboard.php
@@ -3,7 +3,7 @@
   require 'include/db.inc';
   require 'include/common.inc';
   
   require 'include/db.inc';
   require 'include/common.inc';
   

-  if($_GET['mnumber']!="" &&
+  if( isset($_GET['mnumber']) &&

      $db->query("SELECT COUNT(*) FROM students WHERE mnumber=" . trim($_GET['mnumber']) . " AND lastblackboard=" . trim($_GET['tstamp']))->fetch(PDO::FETCH_NUM)[0] == 0) {
      
     if( $_GET['sign'] == 0 ) {
      $db->query("SELECT COUNT(*) FROM students WHERE mnumber=" . trim($_GET['mnumber']) . " AND lastblackboard=" . trim($_GET['tstamp']))->fetch(PDO::FETCH_NUM)[0] == 0) {
      
     if( $_GET['sign'] == 0 ) {


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