How to return one random line from the model?

Question

Trying to get one random string from a model. I pulled this from the internet:

$this->Testimonial->findAll(null,null,'rand()',1,null,null);

Unfortunately findAll no longer exists in cakephp 1.3

+3

Jack b nimble Mar 11 '11 at 6:23

2 answers

you can try the following:

$count = $this->Testimonial->find('count');
$this->Testimonial->find('first', array('conditions' => array('id' => rand(1,$count))));

(this also does not return "all" results)

+2

Thomas Mar 11 '11 at 10:46

Martin ueding · Accepted Answer · 2011-08-12T21:18:33+0000

$this->Quote->find('first', array('order' => array('rand()')))