Simple question:

Php code:


<?php
$db_name = "abc";
$link = mysql_connect("abc", "abc", "abc) or die("Could not connect to server!");
$table_name = 'journals';

$select_db = mysql_select_db($db_name, $link);
$query = "SELECT * FROM " . $table_name;

$result = mysql_query($query, $link) or die("Could not complete database query");
$num = mysql_num_rows($result);

if ($num != 0) {
$file= fopen("results.xml" , "w");
$_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n";
$_xml .="<$table_name>\r\n";

$row = mysql_fetch_array($result);

while (list($key,$value) = each ($row)){

$_xml .=" <$key>$value</$key>\r\n";

}



$_xml .="</$table_name>";


fwrite($file, $_xml);
fclose($file);
echo $_xml;

}
else {
echo "No Records found";
}

?>

Output:


<?xml version="1.0" encoding="UTF-8" ?>
<journals>
<0>1</0>
<journal_id>1</journal_id>
<1>newsweek</1>
<journal_path>newsweek</journal_path>
<2>Newsweek</2>
<journal_title>Newsweek</journal_title>
<3>The Weekly Magazine</3>
<journal_subtitle>The Weekly Magazine</journal_subtitle>
</journals>

Desired Output:
<?xml version="1.0" encoding="UTF-8" ?>
<journals>
<journal_id>1</journal_id>
<journal_path>newsweek</journal_path>
<journal_title>Newsweek</journal_title>
<journal_subtitle>The Weekly Magazine</journal_subtitle>
</journals>

I know, I could be using $row[journal_id],$row[journal_path] and so on, but the point is, I wanted to make this as modular as possible.
What am I doing wrong...?
Any assistance will be greatly appreciated.
Thank you!