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/admin/views/giglog_admin_page.php | 2 +- includes/public/shortcodes/giglog_bands.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/includes/admin/views/giglog_admin_page.php b/includes/admin/views/giglog_admin_page.php index 4f24892..4bf052f 100644 --- a/includes/admin/views/giglog_admin_page.php +++ b/includes/admin/views/giglog_admin_page.php @@ -143,7 +143,7 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) { $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" ; $results = $wpdb->get_results($query); $lastType = ''; 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