diff options
| author | AndreaChirulescu <andrea.chirulescu@gmail.com> | 2021-04-07 21:59:19 +0200 |
|---|---|---|
| committer | AndreaChirulescu <andrea.chirulescu@gmail.com> | 2021-04-07 21:59:19 +0200 |
| commit | 6fb98b6f0f7cd077b52ec8e4f0eb9fbd72eed34d (patch) | |
| tree | f233232e0315525ba118159136b2de446cf02d86 | |
| parent | 4f34c1ae93330e142c75f181d4d0c8c2fa8e4bdc (diff) | |
| download | gigologadmin-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
| -rw-r--r-- | includes/admin/views/giglog_admin_page.php | 2 | ||||
| -rw-r--r-- | 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);
|