Random Query

[eluser]CtheB[/eluser]
Sorry i don't use active record in codeigniter so i can't help you.

It is much easier to do it like this:

$query = $this->db->query("SELECT * FROM orders where activated = 1 AND expired = 0 ORDER BY rand() ");
return $query->result_array();