How do I get round using a delimiter in mysql 5

Discussion in 'Databases' started by countrydj, Jan 3, 2011.

  1. #1
    Happy New Year everybody...

    I have moved my notice board from a server running php 3 and mysql 3 to a server running php 5 and mysql 5.

    On the old server, if somebody wrote " it's mine" it would accept it into the database.
    On the new server, if somebody wrote "it's mine" the database won't accept it.
    They have to write "it\'s mine". The user won't get round this.

    How can I get round it?

    Regards,

    John C
     
    countrydj, Jan 3, 2011 IP
  2. jkl6

    jkl6 Peon

    Messages:
    70
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I think this is because you moved from php3 to php5. There's a setting called "magic_quotes_gpc", if turned ON, it automatically adds slashes before quotes. I think in php5, it might be OFF by default. Try turning it on in your php.ini file.
     
    jkl6, Jan 6, 2011 IP
  3. countrydj

    countrydj Active Member

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    91
    #3
    Many thanks jkl6..
    I figured this out a few days ago.
    I put this on 2 threads, PHP and MYSQL. I wasn't sure what the problem was.
    I put a notice on the other thread saying that I had solved the problem
    Thanks for taking the trouble to answer.

    John C
     
    countrydj, Jan 6, 2011 IP