php生成xml问题
<?
include("conn.php");
$startdate = "2005-10-20";
$enddate = "2005-10-24";
echo $enddate ;
$sql = "select * from money_qyl where d >'".$startdate." 00:00:00'and d <'".$enddate." 00:00:00'";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
echo $sql ;
/**/
$varfile= "<?xml version='1.0' encoding='UTF-8'?>";
$varfile.= "<players>";
/**/
while ($row = mysql_fetch_assoc($result))
{
$varfile.= "<player playerId=$row['partner']>";
$varfile.= "<consumption date=$row['d'] param='installed' value=$row['reg_real'] />";
$varfile.= "</player>";
}
$varfile.= "</players>";
echo $varfile;
$fp = fopen('name.xml', 'w');
fwrite($fp, $varfile);
?>