<? 

//***************************************************************************/

//*** delBase RSS DataBase rss feed *********************************************************


include("feedcreator.class.php"); 

$rss = new UniversalFeedCreator(); 
$rss->useCached(); // use cached version if age<1 hour
//$rss->title = "Bookmarks"; 
//$rss->description = "Bookmarks"; 


//$rss->link = "http://www.TheHouseOfOojah.com.au/"; 
$rss->syndicationURL = "http://www.TheHouseOfOojah.com/feed".$_SERVER["PHP_SELF"]; 

//$image = new FeedImage(); 
//$image->title = "AudioBooks"; 
//$image->url = "http://www.girrlz-bookz.com.au/skins/girrlzwithads/media/Girrlz-Bookz-logo.jpg"; 
//$image->link = "http://www.girrlz-bookz.com.au/"; 
//$image->description = "www.Girrlz-Bookz.com.au Lesbian Books"; 

//optional
//$image->descriptionTruncSize = 50;
//$image->descriptionHtmlSyndicated = true;

//$rss->image = $image; 

// added to connect to server?
$mysql_link = mysql_connect ("localhost", "gregoz_delbase", "willunga") or die ('I cannot connect to the database because: ' . mysql_error());
// is this a duplicated redundant command?
mysql_select_db("gregoz_delbase", $mysql_link); 
$res = mysql_query("SELECT * FROM deltable WHERE tags like '%audio%' ORDER by rand() LIMIT 100"); 
while ($data = mysql_fetch_object($res)) { 
    $item = new FeedItem(); 
    $item->title = $data->description; 

	
	$item->link = $data->url;
	
	// mix the tags and the description together
    $item->description = $data->tags . $data->description;
     
    $item->source = "http://www.TheHouseOfOojah.com.au/"; 
    $item->author = "The House of Oojah"; 
	

    $rss->addItem($item); 
} 

// valid format strings are: RSS0.91, RSS1.0, RSS2.0, PIE0.1 (deprecated),
// MBOX, OPML, ATOM, ATOM0.3, HTML, JS
echo $rss->saveFeed("RSS2.0");

?>