summaryrefslogtreecommitdiffstats
path: root/includes/concert.php
diff options
context:
space:
mode:
authorAndreaChirulescu <andrea.chirulescu@gmail.com>2021-09-04 21:36:25 +0200
committerAndreaChirulescu <andrea.chirulescu@gmail.com>2021-09-04 21:36:25 +0200
commit88244b19533163564098057c75952deffc7dc13e (patch)
tree3b1c1a848039324029338b36f894b6d04a4cd86c /includes/concert.php
parentdf6eca59b3a6c33f6135f26a21dfa179ee1414e2 (diff)
downloadgigologadmin-88244b19533163564098057c75952deffc7dc13e.tar.gz
gigologadmin-88244b19533163564098057c75952deffc7dc13e.tar.bz2
gigologadmin-88244b19533163564098057c75952deffc7dc13e.zip
Fixed a call to city() method in concert.php It needed ->venue->city
Added order by concert date in concert list
Diffstat (limited to 'includes/concert.php')
-rw-r--r--includes/concert.php2
1 files changed, 2 insertions, 0 deletions
diff --git a/includes/concert.php b/includes/concert.php
index a533679..8210b2d 100644
--- a/includes/concert.php
+++ b/includes/concert.php
@@ -85,6 +85,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) {
$query = self::BASE_QUERY
. 'WHERE ' . $wpdb->prepare('wpg_concerts.id = %d', $id);
+ $query.= ' ORDER BY wpgconcert_date';
$results = $wpdb->get_results($query);
@@ -219,6 +220,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) {
if ( ! empty( $where ) ) {
$query .= 'WHERE ' . implode(' and ', $where);
}
+ $query.= ' ORDER BY wpgconcert_date';
$results = $wpdb->get_results($query);