Welcome Guest, Not a member yet? Register   Sign In
where match problem
#1

[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


Messages In This Thread
where match problem - by El Forum - 01-23-2011, 12:46 AM
where match problem - by El Forum - 01-23-2011, 08:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB