Quotation or Apostrophe in text input, I can't store it in my database

[tsoltysiak]

Hi,

I have a simple POST form to insert a new entry to my mysql database using php.  It works fine with normal text, but if in the input there is a " or ', it can't add it (it.  How do I get the php to ignore the quotes and apostrophes from the inputs?  I tried putting a \ before the quote in the input field, but it just adds up to the backslash into the database, and messes up once it reaches the quotation.

Thanks for your help,

Tom

[scotmcc]

mysql_real_escape_string

 

See: http://us.php.net/manual/en/function.mysql-real-escape-string.php

[tsoltysiak]

Thanks, that's exactly what I needed.