Fra SQL til XML

PHP kode 

 $data = mysql_query("SELECT...");
 if(mysql_num_rows($data) > 0){
 echo "<root>";
 
 while($row = mysql_fetch_assoc($data)){
 echo "<item>";
   echo "<title>". $row["title"] ."</title>";
   echo "<date>". $row["date"]."</dsate">;
 echo "</item>";
 }
 
 echo "</root>";
 }

PHP kode 

 echo "<?xml version='1.0'?>\n<produkter count='6'>\n";
 
 $query = mysql_query("SELECT * FROM drikkelse");
 while($row = mysql_fetch_array($query, MYSQL_ASSOC)) {
     echo "<produkt>\n";
     echo "<vare>" . $row['vare'] . "</vare>\n";
     echo "<info>" . $row['info'] . "</info>\n";
     echo "<pris>" . $row['pris'] . "</pris>\n";
     echo "</produkt>\n";
 }
    
 echo "</produkter>";

JScript kode 

 if (window.XMLHttpRequest)
   {// code for IE7+, Firefox, Chrome, Opera, Safari
   xmlhttp=new XMLHttpRequest();
   }
 else
   {// code for IE6, IE5
   xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
   }
 xmlhttp.open("GET","http://offlines.dk/otg/ret.php",false);
 xmlhttp.send();
 xmlDoc=xmlhttp.responseXML; 
 
 document.write("<table border='1'>");
 var x=xmlDoc.getElementsByTagName("madplan");
 for (i=0;i<x.length;i++)
   { 
   document.write("<tr><td><b>Dag</b></td><td>");
   document.write(x[i].getElementsByTagName("ugedag")[0].childNodes[0].nodeValue);
   document.write("</td><td><b>Mad</b></td><td>");
   document.write(x[i].getElementsByTagName("mad")[0].childNodes[0].nodeValue);
   document.write("</td><td><b>Mad information</b></td><td>");
   document.write(x[i].getElementsByTagName("madinfo")[0].childNodes[0].nodeValue);
   document.write("</td><td><b>Pris</b></td><td>");
   document.write(x[i].getElementsByTagName("pris")[0].childNodes[0].nodeValue);
   document.write("</td></tr>");
   }
 document.write("</table>");

PHP kode 

 header ("Content-Type:text/xml");

Kode 

This page contains the following errors:

error on line 5 at column 6: Encoding error
Below is a rendering of the page up to the first error.

Mandag