Welcome Guest, Not a member yet? Register   Sign In
Surplus quote mark when ordering by RAND
#1

[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.
#2

[eluser]deadelvis[/eluser]
yeah... this bug is really annoying. Any tips on how to fix it?
#3

[eluser]swissbastian[/eluser]
I agree, it's a pity that this doesn't work correctly.

Please, CodeIgniter folks, fix this bug!




Theme © iAndrew 2016 - Forum software by © MyBB