ki Posted July 7, 2007 Share Posted July 7, 2007 Okay whenever I insert a character like ' into my mysql database my script seems to error? Any suggestions on preventing this error? Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted July 7, 2007 Share Posted July 7, 2007 showing the script would be great, secondly you have to be carefully because if you have string text in your query then a quote will break it but show the script and we can help. Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted July 7, 2007 Share Posted July 7, 2007 If you script errors out when you use ' in your query then you are not escaping it. Always use mysql_real_escape_string when inserting data into the database. Never use raw data straight from the user. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.