]> git.sesse.net Git - ccbs/commitdiff
Order by tournament name as a last resort, to get consistent ordering when two tourna...
authorSteinar H. Gunderson <Steinar H. Gunderson sesse@debian.org>
Thu, 9 Feb 2012 22:22:39 +0000 (23:22 +0100)
committerSteinar H. Gunderson <Steinar H. Gunderson sesse@debian.org>
Thu, 9 Feb 2012 22:22:39 +0000 (23:22 +0100)
html/tournaments.pl

index debc2781d0263a86e0af3f7d59ec970210030392..aedd416dbef607efc77d54dbd010c2a74c0119c9 100755 (executable)
@@ -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 = ();