Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

Moderators: martimiz, UncleCheese, Sean, biapar, Willr, Ingo, swaiba, simon_w

display 3 random dataobjects on frontpage


Reply


2 Posts   929 Views

Avatar
janulka

Community Member, 80 Posts

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

Avatar
SSadmin

Community Member, 90 Posts

2 June 2011 at 9:48am

Select a random row with MySQL:

SELECT column FROM table
ORDER BY RAND()
LIMIT 3

Maybe 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