The location information is not stored in the post_meta table, it’s stored in the em_locations table. You can look up the location using the post_id. Here are some of the fields in the em_locations table:
location_id, post_id, location_name, location_address, location_town, location_state, location_postcode, location_region, location_country, location_latitude, location_longitude, post_content
The post_meta contains the _location_id so you can use that to lookup the location in the em_locations table.
Thread Starter
tkhan
(@tkhan)
Hi thank you, I now have the location id is there a specific events manager output method I can use or do I have to do a database lookup to get the address. Sorry for all the questions but this is new territory for me.
Thanks
Tony
Here’s how you could do it:
$EM_Location = em_get_location($location_id);
echo $EM_Location->full_address();
Thread Starter
tkhan
(@tkhan)
Haha brilliant thank you very much, I was just trying to learn how to query the database you have just saved me from hours of overcomplicating matters.
Thanks Again.
Tony
