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
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,855
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    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
    •