sql - sql查询'IN'操作符不工作错误?
问题描述
我正在使用 CI 'in'operator is not work sql 错误请检查它并分享有价值的想法......
桌子
id | coach_name
------------------
9 | GS
------------------
10 | SLR
视图和功能
$coachID = explode(',',$list['coach']);
$coachname = $this->rail_ceil_model->display_coach_name($coachID);
显示结果
单反
需要结果
GS,单反
最后的查询结果在这里
coach_name
从mcc_coach
哪里选择id
('9','10')
CI 代码
public function display_coach_name($coachID='')
{
$db2 = $this->load->database('rail',TRUE);
$db2->select('coach_name');
$db2->from('mcc_coach');
$db2->where_in('id',$coachID);
$query = $db2->get();
echo $db2->last_query(); die;
if ($query->num_rows() > 0):
//return $query->row()->coach_name;
else:
return 0;
endif;
}
解决方案
您必须向 in 运算符提供一个数组,因此 #coachId 必须是一个数组而不是字符串