I have some articles in a MySQL database which I have inserted manually via WAMP/phpMyAdmin (I typed them in manually, rather than via an 'insert' statement). The problem is, that when I go edit the entry, again via WAMP/phpMyAdmin, I make changes and click save, but the changes aren't saved, they're ignored. I think this is happening because of the quotation marks, but it may also be related to the HTML which I'm included in the article (it's an article about HTML and therefore includes some <pre> tags, and some HTML inside the <pre> tags which is written using HTML entities.). Does anyone know the best way to enter quotation marks and HTML when typing manually, should I be using HTML entities for either the quotation marks of the HTML tags?
Yes. You should escape special characters with a backslash.
If you are adding information within a php program you can use mysql_real_escape_string() or addslashes()
I may have fixed it by placing a backslash before the quotation marks, but I'd appreciate some back-up if anyone agrees with this.