我有错误,如何修复它?“where子句中的列'title‘不明确”:
get_results_from($search_term='default')
$targets=array('a_table','b_table','c_table');
$this->db->select('*');
$this->db->from($targets);
$this->db->like('title',$search_term);
$this->db->or_like('body', $search_term);
$query = $this->db->get();
return $query->result_array();
发布于 2017-05-29 00:45:52
试一试
<?php
get_results_from($search_term='default');
$sql = "SELECT * from a_table where `title` LIKE '%".$search_term."%' OR `body` LIKE '%".$search_term."%'
UNION
SELECT * from b_table where `title` LIKE '%".$search_term."%' OR `body` LIKE '%".$search_term."%'
UNION
SELECT * from c_table where `title` LIKE '%".$search_term."%' OR `body` LIKE '%".$search_term."%' ";
$query = $this->db->query($sql);
return $query->result_array();
?>
发布于 2017-05-29 13:52:06
尝试以下代码:
function get_results_from($search_term='default')
{
$targets=array('a_table','b_table','c_table');
$this->db->select('*');
$this->db->from($targets);
$this->db->group_start();
$this->db->like('a_table.title',$search_term);
$this->db->or_like('b_table.title',$search_term);
$this->db->or_like('c_table.title',$search_term);
$this->db->or_like('body', $search_term);
$this->db->group_end();
$query = $this->db->get();
return $query->result_array();
}
https://stackoverflow.com/questions/44229693
复制相似问题