Once again, I turn to you all, the experts, with what will probably end up being yet another noob question.
OK I’m using a html text editor to capture “news” items, then posting them to the main page. The problem lies when someone uses a ‘ in the editor. Basicly because I’m capturing this as a variable when I get to my update statement the first ‘ that comes up in the text ends that variable. I’m not sure this makes sense, so I’ll post a sudo-example and update statment.
[B]OK lets pretend that the following is written into the editor:
[I]This is hard and I don’t know what to do
[B]Then on submit it is transfered as:
[I]$news
[B]Now when the update statment is read:
[I]$updatestatment = “update news set news = ‘$news’ where id = $id;
[B]As the contents of $news is written it gets to the ‘ in don’t and considers that as the end of the data and pukes.
The more I read this, the more I get the feeling that I’m not doing a good job of relaying my question.