Support » Plugin: Events Manager » Category information Location – where is it stored?

  • Resolved LCrane86



    I’m still working on the mobile app, but after looking through the SQL backend, I can’t find where the category information is found.

    The obvious place would be in the events table, but all the event_category_id fields are empty. I see event-categories are listed in wp_term_taxonomy table – how can I grab events by category from an SQL query?

    I’ve seen someone offering this code,

    SELECT * FROM wp_em_events WHERE event_category_id = 1 ORDER BY event_start_date ASC

    But, obviously with my event_category_id’s being NULL, I’m wondering how I can pull this information so I can push it out for mobile use?



Viewing 2 replies - 1 through 2 (of 2 total)
  • maybe this sample snippet will help –

    Plugin Author Marcus


    NetWebLogic Support

    categories are custom taxonomies now, some fields were left over from version 4 before we started using custom post types.

    so you’d be using WP functions to find this.

    ideally the best way would be to use our functions, which take care of this for you:

    $events = EM_Events::get(array('category'=>'x'));

    you now have an array of EM_Event objects to work with.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Category information Location – where is it stored?’ is closed to new replies.