From 6fb98b6f0f7cd077b52ec8e4f0eb9fbd72eed34d Mon Sep 17 00:00:00 2001 From: AndreaChirulescu Date: Wed, 7 Apr 2021 21:59:19 +0200 Subject: Added wpgc.id as sort by element for concerts t avoid annoying order changing when page refreshes --- includes/public/shortcodes/giglog_bands.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'includes/public/shortcodes') diff --git a/includes/public/shortcodes/giglog_bands.php b/includes/public/shortcodes/giglog_bands.php index 055ebf8..76187ab 100644 --- a/includes/public/shortcodes/giglog_bands.php +++ b/includes/public/shortcodes/giglog_bands.php @@ -77,7 +77,7 @@ and wpgc.venue = wpgv.id and wpgconcert_date >= CURDATE()"; $query .= ($cty == "ALL") ? "" : " and wpgv.wpgvenue_city='" . $cty . "'"; $query .= ($venue == "0") ? "" : " and wpgv.id='" . $venue . "'"; - $query .= " order by wpgv.wpgvenue_city, wpgconcert_date"; + $query .= " order by wpgv.wpgvenue_city, wpgconcert_date, wpgc.id"; //echo($query); $results = $wpdb->get_results($query); -- cgit v1.2.3