[Resolved] Generate rss xml file script?

[groovything]

does anyone have a good script for generating an xml(rss) file with php?

I want to create an xml file that will enable rss viewers and other websites to get a data feed from my site.

I want to do it so that it updates dynamically, as opposed to just manually creating a flat xml file.

I'm looking for a way to create an xml feed that gets generated from a database call.

[groovything]

<?php header("content-type:text/xml"); 

$xmlOutput.="<?xml version='1.0' encoding='windows-1255'?>";
$xmlOutput.="<rss version='0.91'>";
$xmlOutput.="<channel>";
$xmlOutput.="<title>Groovything.com</title>"; 
$xmlOutput.="<link>[url]http://www.groovything.com[/url]</link>";
$xmlOutput.="<description>Updated every time new content is submitted</description>"; 
$xmlOutput.="<language>en-us</language>"; 
$xmlOutput.="<lastBuildDate>Tue, 03 Feb 04 18:03:40 GMT</lastBuildDate>"; 
$xmlOutput.="<copyright>Copyright: (C) Groovything.com, [url]http://www.groovything.com[/url]</copyright>"; 
$xmlOutput.="<docs>[url]http://www.groovything.com/rss/[/url]</docs>"; 
$xmlOutput.="<image>";
$xmlOutput.="<title>Groovything</title>"; 
$xmlOutput.="<url>[url]http://www.groovything.com/img/thumb_120x60.gif[/url]</url>"; 
$xmlOutput.="<link>[url]http://www.groovything.com[/url]</link>"; 
$xmlOutput.="</image>"; 
include ("../../inc/dbconnect.inc"); 
    //create sql statement        	
$sql = "SELECT * from images where display = 'o' order by imageID desc limit 5"; 
			    //execute sql query and get results     

        $sql_result = mysql_query($sql) or die("Unsuccessful Query."); 
  //format results by row 
        $count = 0;
		while ($row = mysql_fetch_array($sql_result)) { 
          $STRimageID = $row["imageID"];         

          $STRtitle = $row["title"];
          $STRsubmitter = $row["submitter"];
		  $STRdescription = $row["description"];
		  $STRdescription = str_replace( chr(13), "<br>", $STRdescription);
		  $STRscore = $row["score"];
		  $STRpath = $row["path"];
		  $STRthumbPath = str_replace( "imageUpload", "imageUpload/thumb", $STRpath);
		  $STRdate = $row["date"];
		  $STRcategory = $row["category"];

$xmlOutput.="<item>";
$xmlOutput.="<title>".$STRtitle."</title>";
$xmlOutput.="<description><![CDATA[<table border='0'><tr><td><a href='http://www.groovything.com/default.php?menu=img&page=imageDisplay&STRimageID=".$STRimageID."'><img border='0' src='".$STRthumbPath."'></a></td><td>".$STRdescription."</td></tr></table>]]></description>"; 
$xmlOutput.="<link><![CDATA[[url]http://www.groovything.com/default.php?menu=img&page=imageDisplay&STRimageID=[/url]".$STRimageID."]]></link>"; 
$xmlOutput.="</item>";
  }
$xmlOutput.="</channel>";
$xmlOutput.="</rss>";
echo $xmlOutput;
?>