From 3fc5c384357af2b5f14bf1aeb6be27bc4d8f19e4 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Thu, 9 Feb 2012 23:22:39 +0100 Subject: [PATCH] Order by tournament name as a last resort, to get consistent ordering when two tournaments have the same date. --- html/tournaments.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 = (); -- 2.39.2