boxiky/rubrikalist.inc

   1 <table width=100% class=box><tr><td>
   2 <?
   3 $set=$kyberia->query("SELECT articles.id_rubrika,rubriky.nazov as rubrnazov from articles left join rubriky on rubriky.id_rubriky=articles.id_rubrika where id_article='".$_GET['node_id']."'");
   4 $set->next();
   5 echo "<center>kategoria: &nbsp;<b><a href=".SCRIPT."?action=rubrika&kat=",$set->getString("id_rubrika"),">",$set->getString("rubrnazov"),"</a></center></b><br>";
   6 $rubrika=$set->getString("id_rubrika");
   7 $set=$kyberia->query("SELECT id_article,nazov, hits from articles where id_rubrika=$rubrika ORDER by id_article DESC");
   8 $i=0;
   9 while ($set->next()) {
  10         ++$i;
  11         echo $i,".&nbsp;<a href=".SCRIPT."?action=$action&node_id=",$set->getString("id_article"),">",$set->getString("nazov"),"</a><br>";
  12 }
  13
  14 ?>
  15 </td></tr></table>