PHP从MySQL数据库获取数据并生成xml文档

代码如下：(PHP5.2+MySQL5.0)

<?php
// query database for records
$connection = mysql_connect("localhost", "root", "root") or die ("Unable toconnect!");
mysql_select_db("guestbook") or die ("Unable to select database!");
mysql_query("SET NAMES UTF8");
$query = "SELECT date, name, hp, description FROM ylczgb";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

if (mysql_num_rows($result) > 0)
{
    $dom = new DomDocument('1.0','UTF-8');
    $rcs = $dom->createElement("rcs");
    while(list($date, $name, $hp, $description) = mysql_fetch_row($result))
    {
    $rc = $dom->createElement("rc");
    $mydate=$dom->createElement("date");
    $myname = $dom->createElement("name");
    $myhp=$dom->createElement("hp");
    $mydescription=$dom->createElement("description");
    $datetext = $dom->createTextNode($date);
    $mydate->appendChild($datetext);
    $nametext=$dom->createTextNode($name);
    $myname->appendChild($nametext);
    $hptext=$dom->createTextNode($hp);
    $myhp->appendChild($hptext);
    $descriptiontext=$dom->createTextNode($description);
    $mydescription->appendChild($descriptiontext);
    $rcs->appendChild($rc);
    $rc->appendChild($mydate);
    $rc->appendChild($myname);
    $rc->appendChild($myhp);
    $rc->appendChild($mydescription);
    }
    $dom->appendChild($rcs);
    echo $dom->saveXML();   
}  
// close connection
mysql_close($connection);
?>

生成的xml文档如下：<?xml version="1.0" encoding="utf-8" ?>
<records>
<record>
<date></date>
<summary></summary>
<name></name>
<hp>/hp>
<description></description>
</record>
</records>