Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Sep 2006
    Location
    India Mumbai
    Posts
    248
    Thanks
    13
    Thanked 1 Time in 1 Post

    MSSQL DB - update failing because of round brackets in one of the value

    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

  2. #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    15,016
    Thanks
    164
    Thanked 2,246 Times in 2,233 Posts
    I don't think a bracket could fail a query. Could you echo your query and post the output here?
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •