Problem With WHERE Clause

[eluser]james182[/eluser]
i think i found the problem.
nedd to change '\'E\',\'F\''

Code:

SELECT * FROM (`default_products_diamonds`) WHERE `shape` = 'Princess' AND `colour` IN ('\'E\',\'F\'')

Replace with:

Code:

SELECT * FROM (`default_products_diamonds`) WHERE `shape` = 'Princess' AND `colour` IN ('E','F')

it's coming from here:

Code:

$colours =  implode("','", explode('-', substr_replace($colour ,"",-1)));

Code:

"','"

is getting placed in the query as

Code:

"\',\'"