summaryrefslogtreecommitdiffstats
path: root/includes
diff options
context:
space:
mode:
Diffstat (limited to 'includes')
-rw-r--r--includes/admin/views/giglog_admin_page.php2
-rw-r--r--includes/concert.php2
2 files changed, 3 insertions, 1 deletions
diff --git a/includes/admin/views/giglog_admin_page.php b/includes/admin/views/giglog_admin_page.php
index dfea3fd..ce0031c 100644
--- a/includes/admin/views/giglog_admin_page.php
+++ b/includes/admin/views/giglog_admin_page.php
@@ -223,7 +223,7 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) {
$content .= '<tr class="assignitr">';
if ($lastType != '' && $lastType != $concert->venue()->city()) {
- $content .= '<td>' . $concert->city() . '</td></tr><tr>';
+ $content .= '<td>' . $concert->venue()->city() . '</td></tr><tr>';
}
if ($lastType == '' ) {
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);