I want to select a random object from a a table, MonkeysFist where the selection is restricted by a category with maps to the title of the page. So far I have:

function RandomFist() {
       $MFoptions = DataObject::get_one("MFCategory","title=Title");
      return DataObject::get_one("MonkeysFist","","MFCategoryID = $MFoptions.ID","RAND()") ;
}

This returns a random object but the from any category not restricted as I need to a specific one. What am I doing wrong?

Thanks

MM

Thanks for this but I am still having problems. Changing the code as suggested gives me "The website server has not been able to respond to your request." error.

As I say the issue does not appear to be in this part of the code, I get a random object back with my original code but it is not restricted to the category as defined in the first line.

Any other thoughts would be appreciated

MM

You're right. That won't work.. sorry for not spotting it the first time. It should read:

Well, actually you can't use $MFoptions.ID, it's not valid PHP Code. In PHP, accessing members of an Object always requires the -> operator (except static members of course).
What might have confused you is the syntax used in SilverStripe Templates. There you access members of an Object using the dot (.).