Fetch a Random Database Entry with CakePHP

// This statement queries a Testimonial model for one random entry. 
$this->Testimonial->findAll(null,null,'rand()',1,null,null);

AD7six wrote on 16/7/07:

You'll get headaches doing that with a none-trivial sized table ;), order by rand is the best way to tie up the db calculating random numbers.

Better to return a random result from an ordered resultset. In words:

* get the number of rows (a findCount)

* select a random number between 1 and the max

* find page (random) showing 1 result per 'page'

Cheers,

AD

Ps. I agree with everyone regarding the site design :) 

richard wrote on 2/10/08:

thanks. i thought i have to use like this rand(Profile.id) to get random record. a simple rand() works.

Bharat wrote on 20/5/09:

Yes that wotked perfectly.. Thnks Dear

rahul wrote on 12/10/10:

it's really great ......

 

 

 

Channery wrote on 27/8/11:

Aritcels like these put the consumer in the driver seat-very important.

asepvzdsya wrote on 27/8/11:

54ELa6 yfiyohkoquop

DashKT wrote on 28/8/11:

prednisone no prescription fhq zovirax online cheap aqscd

office2010key wrote on 16/11/11:

The Microsoft office 2011 users can Office 2010 work more efficiently with the Microsoft Office 2010 simple and intuitive Download Office 2010 user interface new graphical MS Office 2010 menus and a familiar Office 2010 Key experience provide the Office 2010 Download tools you need to plan and Office 2010 Professional manage your project. And the Microsoft Office 2010 Download tabs and contextual menu buy microsoft office 2010 groupings reveal powerful features, Windows 7 making it easier to get Microsoft Windows 7 started and realize results Win 7. Simply be more productive Download Windows 7 by choosing your own menu Buy Windows 7 options, quick access Office 2007 toolbar settings and Microsoft Office 2007 setting defaults.Enhanced copy Office 2007 Download and paste makes it easy to Office 2007 Professional share information effectively MS Office 2007 with other Office 2007 Key applications while retaining buy microsoft office 2007 formatting. And the added columns Download Office 2007 dynamically by entering Microsoft Office 2007 Professional data without having to first select purchase microsoft office 2007 the data type.

http://softwarestockss.blogspot.com

http://software-stocks.com

north face outlet store wrote on 30/12/11:

even the north face of magic top of live, also care time of problem, Earth of mother of Lake also loaded can't too more water?" camel kitchen Huan Chuo last by deleting convex words north face store latent tapping twilight Olympics? then pumping words Earth of mother of Hou Garden may will became swamp has! ""What about the north face?" Lucky asked: "do not hole plugging up?""No." Ling said: "here of Lake is temperature of, description near has lava tube through,

5345 wrote on 2/1/12:

Loving the pastels louis vuitton sale for some cause LV clothes normally look greater within the advertisements than even on the runways or red carpet. But for positive this puts me in the mood for some spring time warmth so hurry up and be more than winter louis vuitton speedy mini!I under no circumstances substantially cared for the louis vuitton speedy 25 or this style but I actually really like this bag! I think I was just constantly turned off because these sort of bags look hard to obtain louis vuitton sale into when you are on the go to me?- deciding upon an high priced gift out of thin air may be a daunting process. We are right here to create it just somewhat bit simpler for you with our Holiday louis vuitton speedy 30, and today's installment will concentrate on the safest kind of accessory gift: The Classic Bag.On the other hand, for the fun of it, I just ran this past my husband, who is an lawyer. He opines that Hermes would have grounds to sue simply because one more maker has intentions of turning a profit depending on an louis vuitton speedy'patented style style. In any occasion, I believe these canvas bags are dorky.Appreciate the Louis V and also the retailers have the most beneficial windows of any individual on a continuous basis. Somehow I in no way really like the louis vuitton speedy sale lines, but the LV is superb.What cheap louis vuitton has employed appears to be a lot more of an artistic rendering than a straight-up photo like that applied by louis vuitton luggage Thursday Friday, but apart from that, the idea is exactly the same and I'm betting that Hermes'legal department will react similarlylouis vuitton neverfull and eventually get a comparable settlement.if Hermes is going to invest its income on a court case suing a firm for copying its bags, then speedy louis vuitton should really leave the gently humorous canvas bags alone and go soon after chain retail stores that sell carbon-copy versions of its bags instead.