where match problem

[eluser]nuclearmaker[/eluser]
why

Code:

$this->db->where('MATCH (`title`,`desc`) AGAINST ('. $q .')', NULL, TRUE);
$this->db->order_by("created_at", "desc");

will result as

Code:

SELECT * FROM (`codeigniter`) WHERE `MATCH` (`title`,`desc`) AGAINST ('codeigniter') ORDER BY `created_at` desc

?? then it will error bcoz backtick at MATCH

[eluser]InsiteFX[/eluser]
You shoud read the CodeIgniter User Guide!

CodeIgniter User Guide - Active Record Class

InsiteFX