+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Surplus quote mark when ordering by RAND (/showthread.php?tid=13575)
Surplus quote mark when ordering by RAND - El Forum - 11-27-2008
[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.
Surplus quote mark when ordering by RAND - El Forum - 12-01-2008
[eluser]deadelvis[/eluser]
yeah... this bug is really annoying. Any tips on how to fix it?
Surplus quote mark when ordering by RAND - El Forum - 01-09-2009
[eluser]swissbastian[/eluser]
I agree, it's a pity that this doesn't work correctly.
Please, CodeIgniter folks, fix this bug!