CodeIgniter Forums

Full Version: Surplus quote mark when ordering by RAND
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

I think I've found a bug

$query = $this->CI->db->get('tracks');

produces a db error with SQL output of:

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.

El Forum

yeah... this bug is really annoying. Any tips on how to fix it?

El Forum

I agree, it's a pity that this doesn't work correctly.

Please, CodeIgniter folks, fix this bug!