Hi folks,

I’m trying to set up Wordpress/Flash so that special characters (specifically &,“,”,‘,’%, etc) appear correctly in Flash.

I know that the best way is to convert everything, eg ‘&’ to ‘%26’.

Can I adjust my php query to do this conversion for me?

Any info much appreciated!

Here's what I've been trying ( $row = str_replace("%26", "&", $row);) , but without any luck:

/* Fetch all the data from wp_posts table */
for ($i=0; $i< $nRows; $i++){
$row = mysql_fetch_array($qResult);
$row = str_replace("%26", "&", $row);
$rString .="&ID".$i."=".$i."&"."&post_title".$i."=".$row['post_title']."&"."&post_date".$i."
=".$row['post_date']."&"."&post_content".$i."=".$row['post_content']."&"."&
prepic".$i."=".$row['meta_value']."&";
}
/* Output the data as a string so Flash can read it */
echo $rString."&";

Hmmm I'm still having big problems with curly quote marks and curly double quote marks (whatever their proper name might be).

In the mySQl database, double quote marks show up as 'Â' or 'â'

... but only the 'Â's show up correctly as “s and ”s

The 'â's appear in Flash as weird things like €" or €™, does anyone know why?