<?php
	/*******************************************************************************
     **  File          :  spot_qry_rss.php                                        **
     **  Author        :  G.Ramkumar                                              **
     **  Description   :  spotnews displaying in xml view						  **
  	 **  Date          :  14/07/2005                                              **
     **  Last Modified :  02/08/2005                                              **
     **  PHP Version   :  5.0.3                                                   **
     **                                                                           **
     *******************************************************************************/

$comdate=date("Y-m-d")." ".date("H:i:s");

$catname="select * from category where category_name='$newspotlight_' and language='$lang_en'";
$catname_res = $pg_sql->query_pass($catname,"4");

if($_REQUEST['cat_id']!=""&& $_REQUEST['subcat_id']=="")
  $catid_="where category_id=".$_REQUEST['cat_id'];
elseif($_REQUEST['cat_id']!=""&& $_REQUEST['subcat_id']!="")
  $catid_="where subcategory_id=".$_REQUEST['subcat_id'];
else{
   if($catname_res[0]['category_id']!="")
      $catid_="where category_id=".$catname_res[0]['category_id'];
 }

if($catid_!="")
{
	$spot_qry="select * from newsitem_category $catid_ order by id desc";
	$spot_res=$pg_sql->query_pass($spot_qry,"4");
}


$spotcnt=count($spot_res);


?>