<?php  ob_start(); 
require_once ("../globals/config.php");
require_once("../classes/class_database.php"); 
$db=new DataBase(DBHOST,DBNAME,DBUSER,DBPASS); 
$d1=new DataBase(DBHOST,DBNAME,DBUSER,DBPASS); 
// load the URL factory library
require_once 'rss_factory.inc.php';


$rss_feed = new RSSFactory('http://www.Stinkyjournalism.org',
                           date('D').', '.date('d M Y h:i:s'), 
                           'Exciting news Readings ,updated daily');

// create feed

$sql="select *,date_format(news_date,'%a, %d %b %Y') as newdatenews from news where is_blocked=0 order by 	id desc "; 
$res=$db->query($sql);
$count=mysql_num_rows($res);
if($count>0)
{
while($row=mysql_fetch_object($res))
{
	// add feed item
	$rss_feed->addItem($row->title,$row->newdatenews,$row->id,$row->sdesc); 
}

}

// display feed
$data= $rss_feed->get('2.0'); 

$fp=fopen('rssNew.xml','w');
fwrite($fp,$data);
fclose($fp);
?>