char in text causing error
Been messing around with mysql on my website today and it apears when someone adds a comment to my guest book that contains ' it will pull and error like this
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 's life. Then a sharing of her understanding and deeply personal spiritual lesson' at line 1
If i remove them quotes then it will work fine but i need to allow such a thing so how would i go about fixing this?
$dtl = str_replace("'","\'",$dtl);
Never the less is there anything else that i should be aware of that could also cause such a thing?
|All times are GMT. The time now is 04:51 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0