Support

Home Forums Event Espresso Premium Link from event detail and venue tables

Link from event detail and venue tables

Posted: February 25, 2014 at 11:05 am


Amy Bridge

February 25, 2014 at 11:05 am

Let me start by saying sorry if I am just been blonde. Please can you tell me how the event_detail info is linked to the event_venue information.

Thanks very much in advance


Lorenzo Orlando Caum

  • Support Staff

February 25, 2014 at 11:28 am

Hi Amy,

What version of Event Espresso are you currently using?

Also, is this question related to how to add a venue to an existing event or are you looking for information on how the information is stored in the WordPress database?


Lorenzo


Amy Bridge

February 26, 2014 at 11:40 am

Hi Lorenzo,

I have the latest version installed. Sorry I should have been explicit. I am writing a custom report and would like to display the attendee details for a specific event including the venue for that event. So in terms of table joins, what do you join the event table to the venue table on? It would make sense that the event table would have a venue ID, but I cant seem to find it.


Josh

  • Support Staff

February 26, 2014 at 1:09 pm

They’re joined with the events_venue_rel table which is defined as EVENTS_VENUE_REL_TABLE.


Amy Bridge

March 2, 2014 at 10:06 pm

Thanks Josh

The support post ‘Link from event detail and venue tables’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso