[SOLVED] Trouble adding data containing apostrophes (') to database. Please help.

[jacklany]

Hi all.

So i'm trying to add, delete and update fields from a database using forms and textfields.

My code works, except when there are apostrophes (') in the textfields. I suppose it conflicts with the apostrophes in the mysql_query command.

 

Any ideas what my problem is?

thanks for sharing opinions.

[kenrbnsn]

Use the function mysql_real_escape_string() on the values when you insert/update the database.

 

Ken

[jacklany]

So simple! It works. Thanks a lot and sorry for asking a question you've seen a thousand times.