Multiple Keyword Search

[eluser]JoostV[/eluser]
@Lykos22 : The error is here:

Code:

// set condition for this word
$where_str = '(';

foreach ($search_fields as $field) {
    $where_str .= ' OR ' . $field . ' LIKE \'%' . $word . '%\'';
    // $this->db->or_like($field, $word);
}

// remove first ' OR ' and close parenthesis
$where_str .= substr($where_str, 4) . ')';

When you do $where_str .= substr($where_str, 4) . ')'; you are removing the first parenthesis as well. Try this:

Code:

$where_str = '';
foreach ($search_fields as $field) {
    $where_str .= ' OR ' . $field . ' LIKE \'%' . $word . '%\'';
}
// Wrap in parentheses and remove first OR
$where_str = '(' . ltrim($where_str, ' OR ') . ')';