I am trying to put height into mysql database table through an entry made in php. All other fields, name, age, etc. work fine, but when it comes to putting height in the foot-inch format (5'6") there is a problem.
How do I make it so the characters ' and " can be inserted into mysql table?
If it helps, this is the message I get when the form is submitted: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6"')' at line 2