Help needed with search query

[eluser]CroNiX[/eluser]
You'll need to combine all of your wheres into a single where() as this version of CI doesn't have the functionality to break up the wheres into conditionals (the next version does).

Code:

$terms = str_replace(" ", ",", $search_term);

$this->db
  ->select('engines.*, models.model as model_name, makes.make as make_name')
  ->from('engines')
  ->where("(engines.status = 1) AND `models`.`model` IN ('DOHC') OR `engines`.`engine` IN ('DOHC')")
  ->join('models', 'models.id = engines.model')
  ->join('makes', 'makes.id = engines.make')
  ->order_by('makes.make, models.model, engines.first_year', 'ASC')
  ->get('engines');