[SOLVED] making sure characters saved to db remain in the long version, like '£

[cosmicbdog]

hi there, I have a cms and whenever I save a character like &pound to the db and then retrieve it to an editable field again, when it displays in the input, naturally it just displays the actual character and not the longwinded version.

I am wondering if there is a way around this? I don't like the idea of having to each time I want to save something back to the db doing some ereg_replace() script that changes everything as I'd like to keep the character input manual at this stage.

Any ideas?

[cosmicbdog]

To keep it simple, when I save £ to a mysql table and retrieve it to a text input again, i'd like it to output as £ and not actually display the pound symbol.

[Rakuli]

When you write the value to the form element use

PHP: Select all

html_entities($text); 

And it will be converted to html entities and displayed literally

[cosmicbdog]

Nice one Rakuli. Thank you.

htmlentities($text) ended up doing the trick!