Hello!
I have used a script that get info from my MySQL server and then diplay it, it generates an XML file and here is my problem:
After it have recceved the info from the myslq server it displays everyting correct but there is one problem… no matter what I have tryed it just wont show Å,Ä,Ö… i have tryed different UTF-8, encodings, including in the php an function that replaces the Å,Ä,Ö with the correct html code: å ä ö that is used to display these words… but nothing works… I hope there is some flash guru here that can help me with this!
here is the php code that generates the XML file that Flash read:
<?php
#***********************************
#XML OUTPUT
#*********************************
include(‘admin/functions.php’);
connect(‘x’, ‘x’, ‘x’, ‘localhost’);
$query = ‘SELECT id, author, title, body, FROM_UNIXTIME(timestamp, ‘%M %D %Y’) date***
*****************FROM flash_news
********************LIMIT 20’;
$result = mysql_query($query);
$nl = "
";
****echo ‘<?xml version=“1.0” encoding=“UTF-8”?>’ . $nl;
**echo ‘<ROOT>’ . $nl;
while($r = mysql_fetch_array($result)){
echo ‘<news id="’ . $r[‘id’] . ‘" title="’ . stripslashes2($r[‘title’]) . ‘" date="’ . $r[‘date’] . ‘" author="’ .
stripslashes2($r[‘author’]) . ‘">’ . $nl;
****echo ‘<body><![CDATA[’ . stripslashes2($r[‘body’]) . ‘]]></body>’ . $nl;
****echo ‘</news>’ . $nl;
}
echo ‘</ROOT>’ . $nl;
?>
plzzz help im loosing my mind here! 