Problem With WHERE Clause

[eluser]james182[/eluser]
Using this:

Code:

$sql = 'SELECT * FROM products_diamonds WHERE (shape=? AND carat >= ? AND carat <= ? AND (cost BETWEEN ? AND  ?)) OR colour in (?) OR clarity in(?) OR certification_type in(?)';
$query = $this->db->query($query, array($shape, $min_carat, $max_carat, $min_price, $max_carat,$colours,$clarities,$certifications));

Displays colour data:

Code:

OR colour in ('\'D\',\'E\',\'F\'')

Gives the error: Table 'products_diamonds' doesn't exist.

Which it does exist.

What should the input data be for $colours, etc...? Currently it's 'D','E','F','G'

$this->db->get('products_diamonds'); // Works