From: Steinar H. Gunderson <Steinar H. Gunderson sesse@debian.org>
Date: Thu, 9 Feb 2012 22:22:39 +0000 (+0100)
Subject: Order by tournament name as a last resort, to get consistent ordering when two tourna... 
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=3fc5c384357af2b5f14bf1aeb6be27bc4d8f19e4

Order by tournament name as a last resort, to get consistent ordering when two tournaments have the same date.
---

diff --git a/html/tournaments.pl b/html/tournaments.pl
index debc278..aedd416 100755
--- a/html/tournaments.pl
+++ b/html/tournaments.pl
@@ -5,7 +5,7 @@ use strict;
 use warnings;
 
 my $dbh = ccbs::db_connect();
-my $tournaments = ccbs::db_fetch_all($dbh, 'SELECT * FROM tournaments NATURAL JOIN seasons ORDER BY season, date');
+my $tournaments = ccbs::db_fetch_all($dbh, 'SELECT * FROM tournaments NATURAL JOIN seasons ORDER BY season, date, tournamentname');
 
 # Translate the season names
 my @t_trans = ();