Welcome Guest, Not a member yet? Register   Sign In
CI FULLTEXT pagination
#2

[eluser]smartweb[/eluser]
My wrong class here

function getproudctsList($page,$pagesize,$class,$region)//产品列表
{
//$sql = "select * from coname_infor where match (coname) AGAINST ('".$t."*' IN BOOLEAN MODE) ";
//
$str_search=$class." ".$region."*";
$query=$this->db->where("MATCH (`title`,`body`) AGAINST ('$str_search' IN BOOLEAN MODE)")->get("test");
$this->total ==$query->num_rows();
$query=$this->db->where("MATCH (`title`,`body`) AGAINST ('$str_search' IN BOOLEAN MODE)")->get("test",$pagesize,$page)->result_array();

return $query;
}


return error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AGAINST ('all all*' IN BOOLEAN MODE)' at line 3


Messages In This Thread
CI FULLTEXT pagination - by El Forum - 05-21-2012, 06:05 AM
CI FULLTEXT pagination - by El Forum - 05-21-2012, 06:29 AM



Theme © iAndrew 2016 - Forum software by © MyBB