List Venues with upcoming events only

[Jukka Varis]

Hello,

How do I list all venue names which have events that are currently happening or upcoming?

I got following code to list events:

<?php
$venues = eo_get_venues('number=15'); 
if( $venues ){
    echo '
'; 
    foreach($venues as $venue): 
         $venue_id = (int) $venue->term_id;
              printf('%s', eo_get_venue_link($venue_id), esc_html($venue->name));
    endforeach; 
    echo '';
 }
?>

What should I add there?

Thanks!

[Stephen Harris]

Hi Jukka,

There’s no argument that allows you to use eo_get_venues() to retrieve only venues with future events, you’d have to construct your own sql query for that. One way (although fairly inefficient) is to do check each venue in turn:

foreach($venues as $venue): 

     $venue_id = (int) $venue->term_id;
     $future_events_at_venue = eo_get_events( array(
          'event_end_after' => 'now',
          'tax_query' => array(
                array(
                   'taxonomy' => 'actor',
                   'field'    => 'term_id',
                   'terms'    => $venue_id,
                ),
          ),
     ));

     if ( $future_events_at_venue ) {
          printf('%s', eo_get_venue_link($venue_id), esc_html($venue->name));
     }

endforeach;

[Author]

Posts