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') 

 

 

[Barand]

looks like you were nearly there

 

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

[james182]

I have that too.

but why is it adding the \' to it ???

 

the \' is stopping my query from working..

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

[Barand]

Are you posting $colours to another page with magic_quotes switched on?