replace special chars Reg Exp?

[skip]

Hi All,

I need to replace trademarks copyrights single quotes in one go from a mysql text field whats the best way to doit ?

seems to fall over at (tm) no matter what I do the trademarks are not in the db as the html they show like this ™

Have tried striptags htmlspecialchars( stripslashes($dbVar)) etc etc

its driving me nuts any help would be very much appreiciated

thanks

[Rodney_H_]

Have you looked at the PHP string replace function? http://us2.php.net/str_replace Read the manual, cos I think this is what will help you... good luck! 😃

[skip]

cheers dude doesn't really help though I have tride this

function unaccent($text){
$trans = get_html_translation_table(HTML_ENTITIES); //Get the entities table into an array
foreach ($trans as $literal =>$entity){ //Create two arrays, for accented and unaccented forms
   if (ord($literal)>=192){ //Don't contemplate other characters such as fractions, quotes etc
     $replace[]=substr($entity,1,1); //Get 'E' from string '&Eaccute' etc.
     $search[]=$literal;}} //Get accented form of the letter
return str_replace($search, $replace, $text);}

used on

echo "<handset_description><![CDATA['".unaccent(htmlspecialchars($o['handset_description']))."']]></handset_description>\n";

output:

http://www.sellfones.net/xml-out.php?feed=phones&affil=21

the above contains both single and double quotes other instances include trademarks and copyrights.

My php is very poor im just learning so if I have overlooked anything from your link im sorry

[d_l]

A couple of links I found recently in trying to substitute the copyright symbol

http://lists.w3.org/Archives/Public/html-tidy/2002JanMar/0234.html

http://uk.php.net/manual/en/function.htmlentities.php

If you have PHP5 .. you could try the HTML Tidy PEAR extension.