代码点火器OR AND multiple Where子句 - Code Igniter OR AND multiple Where clause

Code Igniter OR AND multiple Where clause

使用CodeIgniter，我想在Where子句中使用OR进行多重搜索。。像这样的东西：

$sql = "select employee.first_name, employee.last_name, employee.phone_number, job.title,
FROM employee, job
WHERE employee.jobID = job.jobID
AND employee.deleted = 0
AND (employee.first_name = $searchPara OR employee.last_name= $searchPara)
ORDER BY employee.last_name";
return $this->db->query($sql, $searchPara);

上面的查询给出了一条错误消息，而且我不确定如何在job.title=$searchPara上包含搜索。。。在同一SQL语句中

有人能帮我做这个吗？

感谢堆

由于job.title 后的逗号导致SQL错误

$sql = "select employee.first_name, employee.last_name, employee.phone_number, job.title
    FROM employee, job
    WHERE employee.jobID = job.jobID
    AND employee.deleted = 0
    AND (employee.first_name = ? OR employee.last_name = ?)
    ORDER BY employee.last_name";
return $this->db->query($sql, array($searchPara, $searchPara));