7913 Posts in 1355 Topics by 930 members
DataObjectManager Module
SilverStripe Forums » DataObjectManager Module » display 3 random dataobjects on frontpage
Discuss the DataObjectManager module, and the related ImageGallery module.
Moderators: martimiz, UncleCheese, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 641 Views |
-
display 3 random dataobjects on frontpage
3 May 2011 at 8:15am
I have 4 pages / categories, each with several dataobjects.
I would like to display 3 random dataobjects from each page / category on the frontpage, how do I do it?
thanks
-
Re: display 3 random dataobjects on frontpage
2 June 2011 at 9:48am
Select a random row with MySQL:
SELECT column FROM table
ORDER BY RAND()
LIMIT 3Maybe using DataObject::get("YourDataobject",$where,"","sort") statement
DataObject::get( $callerClass, [$filter = ""], [$sort = ""], [$join = ""], [$limit = ""], [$containerClass = "DataObjectSet"] )
put ORDER BY RAND() in to sort field
and set limit to 3
should be okay.DataObject::get("YourDataobject",$where,"ORDER BY RAND()","","3");
Cheers
| 641 Views | ||
|
Page:
1
|
Go to Top |
