Get list of all venues

[Dan]

Hi, I’m having trouble getting a list of all available venues. I assume this would be a DB query, but I’m not sure where the field is or what the column name would be. If there’s a function that already exists, that’d be great.

[Dan]

So I was able to get it out of the database using

$venues = $wpdb->get_col(“SELECT meta_value FROM $wpdb->postmeta WHERE meta_key = ‘_EventVenueID'”);

then running it through array_unique(); and running that list through tribe_get_venue(). Is this the best way to do it, or do you have a function that doesn’t require running it through a DB query?

[Henry]

The best way to list all venues is to do something like this:

have_posts()) : $event_archive_query->the_post(); ?>
<a href="” title=””>

[Henry]

Apologies for the code paste going wrong. See:

http://pastebin.com/8DfZgpbc

[Rob]

Thanks for sharing this, Henry.

Dan: can you give it a go and see if you’re still having issues from there?

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts