Concating problem...

[SubXO]

$query = "update Gender SET Other_Ethnicity = concat(Other_Ethnicity, " || $ethnicity)";

I'm at a loss here on what to do....

I'm trying to set the value of "Other_Ethnicity" to concat with " || " and the value of $ethnicity

Thank you very much for all your help! :-)

[LordShryku]

$query = "UPDATE Gender 
          SET Other_Ethnicity = concat(Other_Ethnicity, ' || ".$ethnicity."')"; 

Try that