xml output

[Rollo_Tamasi]

i have a php file rendering a xml file. I need the xml file to be outputted in the following form

<song name ="name" band ="band" file="file.mp3" />

The php file queries the db for the above fields. The php code i had was this

$xml_output .= "\t\t<band>" . $row['band'] . "</band>\n";

however that outputed the xml as

<band>band</band>

how do i alter the php code to get the desired output?
thanks

[etully]

$xml_output .= "<song name=\"" . $row['name'] . "\" band=\"" . $row['band'] . "\" file=\"" . $row['file'] . "\" />";

The code above assumes that the three rows you are reading from your database are:
$row['name']
$row['band']
$row['file']

If you are selecting them from the table as something other than, name, band, and file then replace as necessary.