Show multiple Venues that are recommended for a type of Catering Event. Filter, Where, If Match
I need to show multiple Venues that are recommended for a type of Catering Event.
For example: There are 4 venues that are recommended for corporate catering events, and 12 venues recommended for wedding catering events.
I need to only show the 4 venues assigned to the corporate catering events, and only show the 12 venues for the wedding catering.
In the CMS:
I have a section editor called Venues where I add my venues, and another section editor called Events Catering where I add my event catering types.
In the Events Catering section, I have a pillbox where I can select the "num / title" of the Venues - which I wish to associate with the catering event record I am creating within the Events Catering section.
Below is the code I have been working with, but I can't seem to figure this out though - to get the page to show only the Venues that I have assigned to the Catering Event.
// load records list($venuesRecommendedRecords, $venuesRecommendedMetaData) = getRecords(array( 'tableName' => 'venues', 'where' => " num LIKE '%\t".$events_cateringRecord['recommended_venues']."\t%'", ));
Any suggestions would be greatly appreciated!