Help Query Problem

[james182]

i have a problem.

$colours =  implode("','", explode('-', substr_replace($colour ,"",-1))); // outputs: D','E','F 

"','"

is getting placed in the query as

"\',\'"

need to change '\'E\',\'F\''

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

Needs to be like this:

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

[Weedpacket]

Are you perhaps escaping quotes in your string after putting in the quotes?