Somebody asked this on IRC so I figured I might as write it down.
Q: How do I get one random row from a table?
A:
$cnt=MyTable::doCount(new Criteria());
$c = new Criteria();
$c->setOffset(rand(1,$cnt));
$mydata=MyTable::doSelectOne($c);
June 3rd, 2009 | by dartarrow | geeky
Jun
03
Somebody asked this on IRC so I figured I might as write it down.
Q: How do I get one random row from a table?
A:
$cnt=MyTable::doCount(new Criteria());
$c = new Criteria();
$c->setOffset(rand(1,$cnt));
$mydata=MyTable::doSelectOne($c);