php xml

[Derzz]

pero esta igual
om como deberia ser

Código PHP:

"<song title=".$row['nombre']."path=".$row['ruta']."/>\n";
 

ayudenme con este codigo

Código PHP:

<?php
 
/*
This is a sample file that extracts a list of records from a mysql database and 
builds a playlist from it. After looking through this file, you'll probably
'get the idea' and'll be able to connect the flash player
to your own database.
*/
 
 
// first connect to database
$dbcnx = @mysql_connect("localhost","derzz_web","xxxxxx");
$dbselect = @mysql_select_db("derzz_musik");
if ((!$dbcnx) || (!$dbselect)) { echo "Can't connect to database"; }
 
 
// next, query for a list of titles, files and links.
$query = "SELECT nombre,ruta FROM archivos_mp3";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
 
// third, the playlist is built in an xspf format
// we'll first add an xml header and the opening tags .. 
header("content-type:text/xml;charset=utf-8");
 
 
echo "<playlist version='1' xmlns='http://xspf.org/ns/0/'>\n";
echo "  <songs>\n";
 
// .. then we loop through the mysql array ..
while($row = @mysql_fetch_array($result)) {
    echo "<song title="$row['nombre']" path="$row['ruta']"/>\n";
    
}
 
// .. and last we add the closing tags
echo "  </songs>\n";
 
 
 
/*
That's it! You can feed this playlist to the SWF by setting this as it's 'file' 
parameter in your HTML.
*/
 
?>
 

quiero hacer la estructura de un XML UTF-8 pero me da error no se como hacerlo
nota: los dato los obtiene de la base de datos que los pone en un bucle

Código PHP:

echo "<song title="$row['nombre']" path="$row['ruta']"/>\n";
 

tengo que canmbiar esta parte

Código PHP:

<playlist version='1' xmlns='http://xspf.org/ns/0/'>
 

por esta

Código PHP:

<?xml version="1.0" encoding="UTF-8"?>
 

de la linea 27