php to xml

[derksj]

Hi

I have this php script that makes an rss feed

rssfeed

<?php 

header ("Content-Type: text/xml"); 
echo '<?xml version="1.0" encoding="ISO-8859-1" ?>'; 

mysql_connect ("localhost", "login", "paswd")
// Input your Database PASSWORD and USERNAME
	or die ("Cannot connect to database server.");
mysql_select_db ("dbname")
	or die ("Cannot connect to database.");
$result = mysql_query ("select * from tabel order by id desc")
	or die (mysql_error());
  echo "<rss version=\"2.0\">\n"; 
  echo "<channel>\n"; 
  echo "<title>vakantiehuizengids titel</title>\n"; 
  echo "<link>[url]http://www.vakantiehuizengids.com/[/url]</link>\n"; 
  echo "<description>Beschrijving vakantiehuizengids</description>\n"; 
while ($row = mysql_fetch_array ($result))
  { 
    $blog_title       = stripslashes($sql->title); 
    $blog_link        = "http://www.vakantiehuizengids.com/propview.php?propnum=".$row['id']; 
    $blog_description = stripslashes($sql->header); 
    echo "<item>\n"; 
    echo "<title>Woning ".$row['id']." ".$row['country']." ".$row['city']."</title>\n";
    echo "<link>".$blog_link."</link>\n"; 
    echo "<description>\n"; 
    echo $row['fulldesc']; 
    echo "</description>\n"; 
echo "<pubdate>\n"; 
    echo $row['dateposted']; 
    echo "</pubdate>\n"; 
    echo "</item>\n"; 
  } 
  // And at last the closing tags for the overall info 
  echo "</channel>\n"; 
  echo "</rss>\n"; 
?>

I understand that if you want to be submitted to rss search engines you have to have an xml file

How can i write this generated xml information to an rssfeed.xml file

greetings Jurgen

[stew]

instead of echoing all the output
such as

echo '<?xml version="1.0" encoding="ISO-8859-1" ?>';  

you could create a string

$output .= '<?xml version="1.0" encoding="ISO-8859-1" ?>';  

then continue to add to the string for each item.

finally

$file = fopen("rss.xml",w+);
fwrite($file,$output);
fclose($file);

but check the manual for the details of the fwrite function

[derksj]

works great

thanks