17487 Posts in 4473 Topics by 1978 members
|Go to End|
24 October 2008 at 10:53am Last edited: 24 October 2008 11:12am
Books can have many categories. Categories can have many books.
I'd like to return a list of books from a specific category.
I have Book.php (extends Page), Category.php (extends DataObject).
$whereStatement = "CategoryID ='". $categoryID ."'";
return DataObject::get("Books", $whereStatement); // Do I replace DataObject with ComponentSet?
The ComponentSet page in the documentation doesn't explain much.
I read that ComponentSet has to do with Many_Many relationships.
Any examples are greatly appreciated!
24 October 2008 at 6:51pm
This did the trick
$ByCategoryID = DataObject::get_one('Category', 'ID="'.$categoryID.'"');
27 October 2008 at 1:44pm Last edited: 27 October 2008 1:45pm
This is much cleaner
|Go to Top|