From 2fec3cd2d3d302dea152569a45e164aa6c7ec6a8 Mon Sep 17 00:00:00 2001
From: Mateja <mail@matejamaric.com>
Date: Mon, 5 Oct 2020 14:32:19 +0200
Subject: Callsign and query fixes

---
 index.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'index.php')

diff --git a/index.php b/index.php
index 5262804..aac73e8 100644
--- a/index.php
+++ b/index.php
@@ -42,12 +42,12 @@ session_start();
     echo "<th>Operator</th>";
     echo "<th>From</th>";
     echo "<th>To</th>";
-    echo "<th>Special sign</th>";
+    echo "<th>Special Callsign</th>";
     echo "<th>Frequencies</th>";
     echo "<th>QSO</th>";
     echo "</tr></thead><tbody>\n";
 
-    foreach($db->query("SELECT * FROM $table where approved=true ORDER BY `id` DESC") as $row) {
+    foreach($db->query("SELECT * FROM $table where approved=true ORDER BY `fromTime`") as $row) {
       echo "<tr>";
       echo "<td>" . $row['operatorCall'] . "</td>";
       echo "<td>" . $row['fromTime'] . "</td>";
-- 
cgit v1.2.3