summaryrefslogtreecommitdiffstats
path: root/includes
diff options
context:
space:
mode:
authorAndreaChirulescu <andrea.chirulescu@gmail.com>2021-04-07 21:59:19 +0200
committerAndreaChirulescu <andrea.chirulescu@gmail.com>2021-04-07 21:59:19 +0200
commit6fb98b6f0f7cd077b52ec8e4f0eb9fbd72eed34d (patch)
treef233232e0315525ba118159136b2de446cf02d86 /includes
parent4f34c1ae93330e142c75f181d4d0c8c2fa8e4bdc (diff)
downloadgigologadmin-6fb98b6f0f7cd077b52ec8e4f0eb9fbd72eed34d.tar.gz
gigologadmin-6fb98b6f0f7cd077b52ec8e4f0eb9fbd72eed34d.tar.bz2
gigologadmin-6fb98b6f0f7cd077b52ec8e4f0eb9fbd72eed34d.zip
Added wpgc.id as sort by element for concerts t avoid annoying order changing when page refreshes
Diffstat (limited to 'includes')
-rw-r--r--includes/admin/views/giglog_admin_page.php2
-rw-r--r--includes/public/shortcodes/giglog_bands.php2
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);