Create xml using database

include("conn.php");

$query = "SELECT * FROM user_record";

$result = mysql_query($query);

$num = mysql_num_rows($result);
$somecontent = '';
for($n=0; $n < $num-1; $n++)
{

$i=$n+1;
$name = mysql_result($result,$i,'name');
$email = mysql_result($result,$i,'email');
$address = mysql_result($result,$i,'address');
$city = mysql_result($result,$i,'city');
$state = mysql_result($result,$i,'state');
$phone = mysql_result($result,$i,'phone');
$cuntery = mysql_result($result,$i,'cuntery');
$image_add = mysql_result($result,$i,'image_add');



$somecontent .= "<$i>";

$somecontent .= "$name";

$somecontent .= "$email";

$somecontent .= "
$address
";
$somecontent .= "$city";
$somecontent .= "$state";

$somecontent .= "$cuntery";
$somecontent .= "$phone";

$somecontent .= "$image_add";
$somecontent .= "";
}
/////////////////////////////////write data in file ////////////////////
$filename = 'c:\webserv\wwwroot\htdocs\san\record.xml';

if (!$handle = fopen($filename, 'a')) {
echo "Cannot open file ($filename)";
exit;
}

if (fwrite($handle, $somecontent) === FALSE) {
echo "Cannot write to file ($filename)";
exit;
}
fclose($handle);

//////////////////////////////////////////// end///////////////////////
?>
conn.php


$localhost = "localhost";
$username = "root";
$password = "";
$database = "record";

mysql_connect($localhost,$username,$password) or die("unable to connect");
mysql_select_db($database);


?>