/**
* This function is used to get the rss
*
* .
*
* @return XML data
*/
function showRss()
{
$sql = " SELECT a.product_id, a.title,a.description, a.thumb_image, a.msrp, a.intro_date,b.soh,sum(c.rating)/count(c.user_id) as\n\t\t\trating\tFROM products_table a INNER JOIN\tproduct_inventory_table b ON a.product_id=b.product_id left join product_reviews_table c on a.product_id=c.product_id WHERE datediff( CURDATE( ) , a.intro_date ) <=100 group by a.product_id order by a.intro_date desc";
$query = new Bin_Query();
$query->executeQuery($sql);
return Core_CRss::writeXML($query->records);
}
/**
* This function is used to get rss
*
* @return XML data
*/
function showRss()
{
header("Content-Type: application/rss+xml");
include_once 'classes/Core/CRss.php';
echo Core_CRss::showRss();
}
