Mysql Entry problem

Discussion in 'PHP' started by meannn, Jan 17, 2010.

  1. #1
    Hello,
    When I try to insert a sentence which has words like these

    <? php ise a good 'language'

    I got syntax errors. I tried htmlentities but not fixed my problem. Please help me, thanks...
     
    meannn, Jan 17, 2010 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    before inserting a text into any column of mysql, single quotes must be escaped using (\).
    eg. php ise a good 'language' should become php ise a good \'language\'

    In php you can do it using addslashes().
     
    mastermunj, Jan 17, 2010 IP
  3. meannn

    meannn Peon

    Messages:
    255
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks a lot!
     
    meannn, Jan 17, 2010 IP