quotes in mysql
I have a lot of people coming to the website putting in characters like so:
Large Pony Hunter (2', 6"); 2008 USEF Zone 3 Children's Large Pony Hunter - 7th place overall;
As soon as this is posted, it deletes everything after the the 6.
Example: Large Pony Hunter (2', 6
When I remove the ", all the data is there. What can I do to prevent this from happening? The weird thing is, it doesn't happen in every field.
It seems to be okay in the admin area so could it be in the php? I have attached the page.
(Its the last field on the page)