[eluser]darrenm[/eluser]
I think I've found a bug
Code:
$this->CI->db->order_by('track','random');
$query = $this->CI->db->get('tracks');
produces a db error with SQL output of:
Code:
SELECT * FROM (`tracks`) ORDER BY ` RAND()
That little quote mark in front of RAND() shouldn't be there.
Also, I shouldn't really have to specify a field name to get random ordering.