shortcode order for event custom post type
ok im working on a website using post type event with post_meta event_start_date, i created a shortcode and everything is displaying fine except for it displaying in order, it seems as its not displaying by using meta_key nor meta_value. this the page http://mixedbagnext.com/wordpress/events/ you'll notice the date order is wrong, i want it to display the most recent date first then the other dates following. side note im using more fields plugin to create post_meta and is set to date entered 2015-01-01. here is my code
// SHORTCODE event
function event_shortcode( $atts ) {
extract( shortcode_atts( array( 'limit' = -1, 'type' = 'event'), $atts ) );
$eventlist = '';
$paged = get_query_var('paged') ? get_query_var('paged') : 1;
$carousel_query = new WP_Query(array (
'posts_per_page' = $limit,
'post_type' = $type,
'post_status' = 'publish',
'order' = 'DESC',
'orderby' = 'meta_value_num',
'meta_key' = 'event_start_date',
'meta_query' = array(
// 'relation' = 'AND',
array(
'key' = 'event_start_date',
'value' = date('Y-m-d', strtotime('-6 hours')), //value of "order-date"
'compare' = '=', //show events greater than or equal to today
'type' = 'CHAR'
)
),
'paged' = $paged ));
if ($carousel_query-have_posts()) :
$eventlist .= 'ul class="event-list clearfix"';
while ($carousel_query-have_posts()) : $carousel_query-the_post();
$event_artist = wp_strip_all_tags( get_the_term_list( get_the_ID(), 'artist_event', ' ', ' , ', ' ') );
$event_start_date = get_post_meta(get_the_ID(), 'event_start_date', true );
$fixed_date_day = strtotime($event_start_date);
$fixed_date_month = strtotime($event_start_date);
$event_start_time = get_post_meta(get_the_ID(), 'event_start_time', true );
$fixed_time_start = strtotime($event_start_time);
$event_end_date = get_post_meta(get_the_ID(), 'event_end_date', true );
$event_end_time = get_post_meta(get_the_ID(), 'event_end_time', true );
$fixed_time_end = strtotime($event_end_time);
$event_location = get_post_meta(get_the_ID(), 'event_location', true );
$event_address = get_post_meta(get_the_ID(), 'event_address', true );
$event_city = get_post_meta(get_the_ID(), 'event_city', true );
$event_state = get_post_meta(get_the_ID(), 'event_state', true );
$event_zipcode = get_post_meta(get_the_ID(), 'event_zipcode', true );
$event_telephone = get_post_meta(get_the_ID(), 'event_telephone', true );
$event_website = get_post_meta(get_the_ID(), 'event_website', true );
$event_description = get_post_meta(get_the_ID(), 'event_description', true );
$event_url = get_post_meta(get_the_ID(), 'event_url', true );
$event_button = get_post_meta(get_the_ID(), 'event_button', true );
$event_btn_img = get_post_meta(get_the_ID(), 'event_btn_img', true );
$event_price = get_post_meta(get_the_ID(), 'event_price', true );
$eventlist .= 'li id="event-list-'. get_the_ID() .'" class="' . implode(' ', get_post_class('clearfix')) . '" '
.'div class="event-list-date"'
.'span class="event-list-day"'.date('d' , $fixed_date_day) .'/span'
.'span class="event-list-month"'.date('M' , $fixed_date_month) .'/span'
.'/div'
.'div class="event-list-title"' . get_the_title() . '/div'
.'div class="event-list-time"span class="yellow-text"time:/span'.date('g:i A' , $fixed_time_start) .'/div'
.'div class="event-list-artist"span class="yellow-text"with:/span'.$event_artist.'/div'
.'div class="event-list-location"span class="yellow-text"location:/span'.$event_city.', '.$event_state.'/div'
.'div class="event-list-link"a href="'.$event_url.'" target="_blank"more info/a/div'
.'/li';
endwhile;
$eventlist .= '/ul';
endif;
wp_reset_query();
return $eventlist;
}
add_shortcode( 'event', 'event_shortcode' );
// the shortcode - [event limit="5"]
Topic meta-query order shortcode custom-post-types Wordpress
Category Web