The forums have permanently moved to forum.kirupa.com. This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.


Results 1 to 3 of 3

Thread: replace ' with ''

  1. #1
    27
    posts
    Registered User

    replace ' with ''

    Hi

    I've got a mySQL database and a php file.
    The php file allows the user to add a comment and that comment is then added to the database.

    Now, everything is working - the comments and database, but when I type in a ' in the comment field, I get this error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version


    Is there a way I can replace the ' with '', because when I type in '' it works and only ' is added to the database.

    Can I do something like this before I add it to the database?
    Code:
    str_replace(','',$comment);
    Can someone please help me.

  2. #2
    Let us live so that when we come to die even the undertaker will be sorry. - Mark Twain
    Don't PM me your CSS, xHTML, JS or PHP questions. I will not reply to ANY IE6 questions.

  3. #3
    27
    posts
    Registered User

    Thank you, the mysql_real_escape_string works perfect.

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
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012