Posted by mantrid on 10/13/06 18:42

thanks all
that was the function i needed
ian

"mantrid" <ian.dandav@virgin.net> wrote in message
news:%sLXg.12972$Or2.7514@newsfe7-gui.ntli.net...
> Hello
>
> I have been getting strange behaviour when using ' in by textboxes.
>
> eg inputting the following
> this is some test text ' and so is this
>
> is saved to the mysql database ok as
>
> this is some test text /' and so is this (with add slashes)
> or
> this is some test text ' and so is this (without add slashes)
>
> mysql field is VARCHAR(255)
>
> but when I retreive the data and display in textboxes on my web page, text
> area type (below) is ok
> <textarea class='BodyText' style='WIDTH: 85%' name="textarea"><?php echo
> $opta; ?></textarea>
>
> but input type (below) cuts everything off after the ' character. However
> this does not happen with other characters such as " or /
> <input type='text' class='BodyText' style='WIDTH: 85%' name='test'
> value='<?php echo $opta; ?>'>
>
> can anyone explain this behaviour and have a solution so that text with
any
> ' characters in it is fully displayed?
>
>
> Ian
>
>

[Back to original message]