Problem With WHERE Clause

[eluser]james182[/eluser]
I am trying to get this to work with showing data where the colour is equal to D,E,F,G.
Post data is:
certi all,
clarity all,
colour = D-E-F-G-,
cut = all,
flou = all,
maxprice = 100000,
maxval = 5,
minprice = 100,
minval = 0.01,
pg = 1,
polish = all,
scat_id = null,
shape = Princess,
sym = all

Code:

public function get_diamond_by_shape($shape,$scat_id,$colour,$clarity,$certification,$cut,$polish,$symmetry,$fluorescence,$min_carat,$max_carat,$min_price,$max_price)
{
  
  //$colours = "'". implode("','", explode('-', substr_replace($colour ,"",-1))) ."'";
  
  
  $colours = explode('-', substr_replace($colour ,"",-1));
  $clarities = explode('-', substr_replace($clarity ,"",-1));
  $certifications = explode('-', substr_replace($certification ,"",-1));  
  
  print_r($shape);
  
  $this->db->where('shape', $shape);
  $this->db->or_where_in('colour', $colours);
  $this->db->or_where_in('clarity', $clarities);
  $this->db->or_where_in('certification_type', $certifications);
  /*
  $this->db->where('cut', $cut);
  $this->db->where('polish', $polish);
  $this->db->where('symmetry', $symmetry);
  $this->db->where('fluorescence', $fluorescence);    
  */
  $this->db->where('carat >=', $min_carat);
  $this->db->where('carat <=', $max_carat) ;
  $this->db->where('cost BETWEEN ' . $min_price . ' AND ' . $max_price);
  
  $diamonds = $this->db->get('products_diamonds');
  
  //print_r($diamonds->result_array());
      
  return $diamonds->result_array();
  
}