www.webdeveloper.com
Results 1 to 2 of 2

Thread: PHP MySQL update syntax when using special characters

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Posts
    421

    PHP MySQL update syntax when using special characters

    I have a database where one of the fields is feet and inches with the special characters, like this 12'1"

    This data is used in this format all over, so I do not want to change it. If I was starting fresh I would separate the fields, use html codes or other things, but I am where I am.

    I am having a hard time doing the updates. I am using this in the update where clause:

    `boat_beam` = '$boat_beam',

    and I am sure I am failing because of the ' around $boat_beam and having ' inside $boat_beam. It updates fine if I use am empty variable.

    This code used to work, until the a recent php upgrade on my server. I have tried replacing the ' around the variable $boat_beam, but I cannot find anything that will work).

    Anyone have the solution? I really need a way to get past this update error leaving the rest of the system intact.

  2. #2
    Join Date
    Nov 2002
    Posts
    421
    Never mind. Got it.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles