Xml Mysql

programming
1

Hi
I need a bit of help with this. I am using some code that I found on the net to make a php script get info from mysql database then return the results in a xml.
[color=#0000ff][color=#000000]The result looks like this [/color][/color][color=red]<[/color][color=red]Record Id>1</Record Id>[/color] but I need the result to look like this [color=red]<Record Record_ID=“1” /> [/color][color=black]Here is the code that I am using:[/color]

 
<?php 
header("Content-type: text/xml"); 
$host = "****"; 
$user = "****"; 
$pass = "****"; 
$database = "****"; 
$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host."); 
mysql_select_db($database, $linkID) or die("Could not find database."); 
$query = "SELECT * FROM Memory ORDER BY Record_Id ASC"; 
$resultID = mysql_query($query, $linkID) or die("Data not found."); 
$xml_output = "<?xml version=\"1.0\"?>
"; 
$xml_output .= "<Memory>
"; 
for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){ 
	$row = mysql_fetch_assoc($resultID); 
	$xml_output .= "	<Memory>
"; 
	 // Escaping illegal characters 
		$row['Record_Id'] = str_replace("&", "&", $row['Record_Id']); 
		$row['Record_Id'] = str_replace("<", "<", $row['Record_Id']); 
		$row['Record_Id'] = str_replace(">", "&gt;", $row['Record_Id']); 
		$row['Record_Id'] = str_replace("\"", "&quot;", $row['Record_Id']);
$xml_output .= "		<Record_Id>" . $row['Record_Id'] . "</Record_Id>
"; 
$xml_output .= "	</Memory>
";
} 
$xml_output .= "</Memory"; 
echo $xml_output; 
?>

If anyone has any idea.

Thanks Tech-Head