I have a 2x2 mysql table called 'Market' that contains an 'ID' column that maps to a Market's 'ID' in the SiteTree, and a 'MarketProducts' column that maps to ProductPage 'ID's in the SiteTree. here is what the table would look like:
ID | MarketProducts
24 | 25,26,28,29
27 | 25,29
on each Market's Page (who's id is contained in the first column, 'ID'), i want to display a Title and link to the ProductPages that are contained in the MarketProducts column. I am currently writing the controller for the class file, but am having problems with the DataObject::get method. here is what i have so far:
$MP = DataObject::get("ProductPage", "ID = $this->MarketProducts");
the MarketProducts datatype is Varchar, and contains multiple IDs, comma separated. not sure if that is messing me up, but i know the syntax is wrong because the whole front end breaks on the Market pages.
sorry if this is a little confusing. I would appreciate any help anyone is willing to offer.