I can't think of any reason you would do this other than storing source code...

Your basically creating a time bomb if anyone from the public has a chance to access this form.
Your having issue with single quotes because you are injecting into the query.
You need to build some security into this and you wont have the issue.

addslashes($str);
mysql_real_escape($str);
htmlentities($str);

I would even go all out and do a str_replace() and preg_match() on some parts of the input and clean it further.
Then when it comes out, to display, do everything in reverse.

But like I said, Time Bomb, you really have to check and double check this input when allowing any type of user input into the database.
If there is a hole, some hacker will find it one day.

One thing you can do when storing raw HTML into a MySQL database is encode it to remove the "special " HTML characters, including the single-quote. When retrieving teh data you decode it to get back the original HTML string.

These two PHP functions will help you out:

PHP htmlspecialchars() Function

PHP htmlspecialchars_decode() Function


Hope this helps!

Bill

Thanks for the help. I'm actually only using it in development through xampp. But this does make want to go back through some other scripts and make them more secure...

I appreciate it..