quackpack
January 26th, 2005, 05:06 AM
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 = "\r\n";
****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! :-(
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 = "\r\n";
****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! :-(