Hi Troy,
Have you tried htmlentities() or html_entity_decode ?
more details:
http://us2.php.net/manual/en/function.html-entity-decode.php
Regards
On 7/16/09, Troy Oltmanns <toltmanns@stripped> wrote:
>
> Hey guys and gals,
>
> I have a little tricky situation so I will explain as best as I can.
>
> I've got a form that loads and saves product data to mysql. In some fields
> like the heading and subhead we use special characters like Omega,
> Registered Trademark, and Ampersand. When putting the data in I will encode
> them as Ω, etc. Once saved, all is good, everything goes ok and will
> display correctly in the user interface. However, if I go back to edit
> that
> product, in the html input element, it will actually display the character
> rather than the entity code (although when checking the source, the html
> entity is coded correctly). Then when it is saved, it saves as the illegal
> character and will serve up a few funky characters in the user interface
> and
> in the database.
>
> I have the code stripping out tags and I tried to use the
> mysql_real_escape_string to no avail.
>
> Anyone have experience with this kind of thing?
> PHP Version 5.1.6*MySQL 5.0.19*
>