Use order(‘RAND()’) in zendframework select query for fetching records in random.
$usersTable = Engine_Api::_()->getItemTable(‘user’);
$select = $usersTable->select()
->where(‘enabled = ?’, 1)
->where(‘approved = ?’, 1)
->order(‘RAND()’)
->limit(5);
Use order(‘RAND()’) in zendframework select query for fetching records in random.
$usersTable = Engine_Api::_()->getItemTable(‘user’);
$select = $usersTable->select()
->where(‘enabled = ?’, 1)
->where(‘approved = ?’, 1)
->order(‘RAND()’)
->limit(5);