Re: updating pages with php
| From: | Liam Gibbs | Date: | Wed, 05 Mar 2003 18:30:34 +0000 |
| Subject: | Re: updating pages with php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-138333@lists.php.net to get a copy of this message | ||
<<The problem I ran into is that mySQL will not allow certain punctuation
inside of a record (no comma's). So now I am left trying to figure out how I
can have the user update the paragraph without having it in a db. Can
someone shoot me in the proper direction? Thanks in advance, your help is
greatly appreciated.>>
Don't forget to escape apostrophes and double quotation marks where needed.
Also, check the actual MySQL. If it contains things like double quotation
marks or greater- or less-than tags, it may be misinterpreted by your
browser when output. A line like:
<INPUT TYPE = "TEXT" VALUE = "$result[0]">
could come out like:
<INPUT TYPE = "TEXT" VALUE = "Example text that screws up
"""><>$%#$" there
it is">
or even in non-form tags.
Try checking both MySQL and the output code in your browser.