PDA

View Full Version : MSSQL DB - update failing because of round brackets in one of the value


bhakti_thakkar
07-15-2008, 08:10 AM
Hi all,
i am using MSSQL + php to update one Product_T table. there are round brackets in the name of the product name ( e.g Shiraz rosé (rosé wine)) how will i eliminate this failing. Below is my code:

product_vc = utf8_decode($product_vc); // utf8_decode for accented characters

i dont kno how to do it with str_replace().

How will i do this. Thanks

abduraooft
07-15-2008, 09:03 AM
I don't think a bracket could fail a query. Could you echo your query and post the output here?