Location: PHPKode > projects > News Manager - RSS aggregator > newsmanager/list_tags_qry.php
<?php
  $total_tag="select distinct(category) from rssurl_newsitem where language='".$lang."' and frontend_export='Y' and category<>''";
  $total_tag_res=$pg_sql->query_pass($total_tag,"4");

  $total_num = count($total_tag_res);
  $limit  = 20; // Set limit display news item per page
  $offset = 0;
  if($_REQUEST['offset']>0){
    $offset = $_REQUEST['offset'];
  }

$tag_list_qry="select distinct(category) from rssurl_newsitem where language='".$lang."' and frontend_export='Y' and category<>'' limit $limit offset $offset";  
$tag_list_qry_res=$pg_sql->query_pass($tag_list_qry,'4');
?>
<table cellpadding="3" cellspacing="0" align="left" width="100%" border="0">
<?
for($lc=0;$lc<count($tag_list_qry_res);$lc++){
  $new_tag=explode("/",$tag_list_qry_res[$lc]['category']);
   for($nt=0;$nt<count($new_tag);$nt++){
	   $newtag_title = $new_tag[$nt];
         if(count($new_tag)>1 && $nt<>0)
          $new_tag[$nt] =$new_tag[0].' '.$new_tag[$nt];
		 else
           $new_tag[$nt]=$new_tag[$nt];   

?>
 <tr align="right" class="cont">
    <td align="left" valign="top"><a href="list_tagitems.php?pid=<?=base64_encode($new_tag[$nt])?>&id=<?=base64_encode($newtag_title)?>&lang=<?=$lang?>" class="contblue2"><?=$new_tag[$nt]?></a></td>
 </tr>
<?}}?>
</table>

Return current item: News Manager - RSS aggregator