More than often while inserting some description into MySQL from a form input one faces a ‘single and double quote’ problem. For example while inserting the following text –
I have both ‘ and ” quotes in my description
To make the text safe for a MySQL insertion parse it with mysql_real_escape_string()
That would make it MySQL safe and would insert the correct text.