The XML produced by a php is not showing greek

[mikek12004]

I am using this code to produce an xml file, do not pay any attetion to the queries the thing is that even if I put the UTF-8 encoding when I try to run the xml file I get the greek characters as invalid, the crazy thing is that if I open it and press enter somewhere or do any other meaningless change and save it then upload it again it works fine (I have windows XP and the server where the script resides is linux-if that plays any role)

$file= fopen("player/".$id.".xml", "w");
            //standard headers
            $xml = "<?php xml version=\"1.0\" encoding=\"ISO-8859-7\"?>\n";
            $xml.="<asx version=\"3.0\" >\n";
            $xml.="<title>General Music ASX playlist</title>\n";
            $xml.="<param name=\"encoding\" value=\"utf-8\" />\n";
            $xml.="<moreinfo href=\"http://www.gm.com\"/>\n";
            for ($i=0;$i<$count;$i++)
                {
                    //get info from database
                    $msg2=explode("/",$msg[$i]);
                    $count2=count($msg2);
                    $code=$msg2[($count2-1)];
                    $pos=strrpos("$code",".");
                        $code=substr($code,0,$pos); //song code
                    $q2= mssql_query("select clroot.Material.description , clroot.item.Code  , clroot.Material.AA ,clroot.item.AA   from (clroot.Material left join clroot.item on clroot.Material.Code=clroot.item.Code) where (  clroot.Material.Code = '$code' )");
                    $r2=mssql_fetch_array($q2);
                    $item2AA=$r2[3];
                    $q3= mssql_query("Select clroot.item.Code from ( clroot.itemrlsn left join clroot.item on clroot.item.AA=clroot.itemrlsn.item2AA ) where(  clroot.itemrlsn.item1AA=$item2AA )");
                    $r3=mssql_fetch_array($q3);
                        $album_code=$r3[0]; //album code
                    $q4=mssql_query("Select Description,BOMAA,Ctgry1,Ctgry2,RecCrD,AltCode,clroot.Material.Code from clroot.material where code='$album_code'");
                    $r4=mssql_fetch_array($q4);
                    $album_description=$r4[0]; //album description
                    $album_BOMAA=$r4[1];
                    $q5=mssql_query("select clroot.Material.Code from (clroot.Material left join clroot.bomLnItm on  clroot.Material.AA=clroot.bomLnItm.MaterialAA) where ( clroot.bomLnItm.BOMCode=$album_BOMAA and clroot.Material.Code >=9.0 and clroot.Material.Code <9.5 and clroot.material.ctgry4!=30)");
                    $r5=mssql_fetch_array($q5);
                    $singer_code=$r5[0];    //singer code
                    $q5=mssql_query("Select descr from clroot.skzoom4 where id='$singer_code'");
                    $r5=mssql_fetch_array($q5);
                    $singer_description=$r5[0];    //singer desc
                    $Qtimi= mssql_query("select retailprice,aa from clroot.material where code='$album_code'");
                    $Rtimi=mssql_fetch_array($Qtimi);
                    $timi1=round("$Rtimi[0]");
                    if ($timi1>$Rtimi[0]) $timi1=$timi1-1;
                    $timi11=stristr("$Rtimi[0]",".");
                    $timi2=substr($timi11,0,3);
                    if ( strlen($timi2)<3 ) $timi2=".00";
                    $timi=$timi1.$timi2; //timi album
                    // create xml entry
                    $xml.="<entry>\n";
                    $display_data=$code."|".$album_code."|".$album_description."|".$singer_code."|".$singer_description."|".$timi."|";
                    $xml.="<title>".$display_data."</title>\n";
                    $xml.="<ref href=\"".$msg[$i]."\" />\n";
                    $xml.="<param name=\"image\" value=\"UserFiles/Image/".$album_code.".jpg\" />\n";
                    $xml.="</entry>\n";
                }
                $xml.="</asx>";
            //custom ones here
 
            fwrite($file, $xml);
            fclose($file);
 

an example output with thee above problem is
http://www.***.gr/player/02.xml
and the corresponding xml looks like

<?php xml version="1.0" encoding="ISO-8859-7"?>
<asx version="3.0" >
<title>General Music ASX playlist</title>
<param name="encoding" value="utf-8" />
<moreinfo href="http://www.gm.com"/>
<entry>
<title>8.01475|1.05059|ΤΑ ΡΕΜΠΕΤΙΚΑ - ΤΑ ΖΕΪΜΠΕΚΙΚΑ ΠΟΥ ΕΓΡΑΨΑΝ ΙΣΤΟΡΙΑ Νο 6|9.00117|ΜΙΧΑΛΗΣ ΔΑΣΚΑΛΑΚΗΣ|8.00|</title>
<ref href="UserFiles/songs/02/8.01475.mp3" />
<param name="image" value="UserFiles/Image/1.05059.jpg" />
</entry>
<entry>
<title>8.01605|2.05008|ΕΠΙΛΟΓΕΣ ΖΕΪΜΠΕΚΙΚΑ|9.00114|ΠΑΝΑΓΙΩΤΗΣ ΜΙΧΑΛΟΠΟΥΛΟΣ|4.40|</title>
<ref href="UserFiles/songs/02/8.01605.mp3" />
<param name="image" value="UserFiles/Image/2.05008.jpg" />
</entry>
<entry>
<title>8.01758|1.05043|Ο ΤΑΣΟΣ ΜΠΟΥΓΑΣ ΣΕ ΤΣΑΚΙΡ ΚΕΦΙ|9.00109|ΤΑΣΟΣ ΜΠΟΥΓΑΣ|8.00|</title>
<ref href="UserFiles/songs/02/8.01758.mp3" />
<param name="image" value="UserFiles/Image/1.05043.jpg" />
</entry>
<entry>
<title>8.01858|1.05060|ΤΑ ΡΕΜΠΕΤΙΚΑ ΤΗΣ ΜΑΓΚΙΑΣ ΚΑΙ ΤΗΣ ΜΑΣΤΟΥΡΑΣ Νο 5|9.00114|ΠΑΝΑΓΙΩΤΗΣ ΜΙΧΑΛΟΠΟΥΛΟΣ|8.00|</title>
<ref href="UserFiles/songs/02/8.01858.mp3" />
<param name="image" value="UserFiles/Image/1.05060.jpg" />
</entry>
<entry>
<title>8.01904|1.05060|ΤΑ ΡΕΜΠΕΤΙΚΑ ΤΗΣ ΜΑΓΚΙΑΣ ΚΑΙ ΤΗΣ ΜΑΣΤΟΥΡΑΣ Νο 5|9.00114|ΠΑΝΑΓΙΩΤΗΣ ΜΙΧΑΛΟΠΟΥΛΟΣ|8.00|</title>
<ref href="UserFiles/songs/02/8.01904.mp3" />
<param name="image" value="UserFiles/Image/1.05060.jpg" />
</entry>
<entry>
<title>8.01937|1.05057|ΤΑ ΡΕΜΠΕΤΙΚΑ - ΦΡΑΓΚΟ ΔΕ Θ' ΑΦΗΣΩ Νο 4|9.00081|ΕΣΚΕΝΑΖΥ ΡΟΖΑ|8.00|</title>
<ref href="UserFiles/songs/02/8.01937.mp3" />
<param name="image" value="UserFiles/Image/1.05057.jpg" />
</entry>
<entry>
<title>8.01950|1.05056|ΤΑ ΡΕΜΠΕΤΙΚΑ - ΣΟΥ ΤΑ 'ΧΩ ΜΑΖΕΜΕΝΑ Νο 1|9.00114|ΠΑΝΑΓΙΩΤΗΣ ΜΙΧΑΛΟΠΟΥΛΟΣ|8.00|</title>
<ref href="UserFiles/songs/02/8.01950.mp3" />
<param name="image" value="UserFiles/Image/1.05056.jpg" />
</entry>
<entry>
<title>8.01964|1.05061|ΤΑ ΡΕΜΠΕΤΙΚΑ - ΑΠ' ΤΗ ΣΜΥΡΝΗ ΣΤΗΝ ΕΛΛΑΔΑ Νο 2|9.00080|ΚΩΣΤΑΣ ΡΟΥΚΟΥΝΑΣ|8.00|</title>
<ref href="UserFiles/songs/02/8.01964.mp3" />
<param name="image" value="UserFiles/Image/1.05061.jpg" />
</entry>
<entry>
<title>8.07834|1.05058|ΤΑ ΡΕΜΠΕΤΙΚΑ - ΕΞΩ ΣΤΕΝΑΧΩΡΙΑ Νο 3|9.00126|ΑΝΘΟΥΛΑ ΑΛΙΦΡΑΓΚΗ|8.00|</title>
<ref href="UserFiles/songs/02/8.07834.mp3" />
<param name="image" value="UserFiles/Image/1.05058.jpg" />
</entry>
<entry>
<title>8.08344|1.04212|ΞΗΜΕΡΩΣΕ ΚΑΙ ΠΑΛΙ ΣΤΟ ΚΑΡΑΒΑΝΙ|9.00045|ΓΙΑΝΝΗΣ ΛΕΜΠΕΣΗΣ|16.00|</title>
<ref href="UserFiles/songs/02/8.08344.mp3" />
<param name="image" value="UserFiles/Image/1.04212.jpg" />
</entry>
<entry>
<title>8.09183|1.05082|ΒΟΤΑΝΑ ΚΑΙ ΚΑΝΑΒΟΥΡΙΕΣ|9.00113|ΠΑΝΟΣ ΑΡΑΒΑΝΙΤΗΣ|8.00|</title>
<ref href="UserFiles/songs/02/8.09183.mp3" />
<param name="image" value="UserFiles/Image/1.05082.jpg" />
</entry>
</asx>
 

any help?

[Dormilich]

you could give utf8_encode() a try if you want to use utf8. then you should declare your xml utf8 too. (but I don't know if it helps, because I don't know which charset your mssql returns)