boxiky/journaux_last.inc

   1 <br><br><center><b>najnovsie denniky</b></center>
   2 <?php
   3 $q="SELECT user_discussion.submission_count as new,dennik.id as id,dennik.nadpis as nadpis,dennik.hits,dennik.prispevky,user.login from dennik left join user on dennik.autor=user.id left join user_discussion on user_discussion.discussion_id=dennik.id_diskuse";
   4 $q.=" order by dennik.id  desc limit 10 ";
   5 $forumset=$kyberia->query($q);
   6 while ($forumset->next()) {
   7         echo "<center><a href='?action=journaux&dennik_id=",$forumset->getString('id'),"'>",$forumset->getString('nadpis'),"</a></center>::>".$forumset->getString('login')."<br>::".$forumset->getString('hits')."&nbsp;hitz ";
   8         echo "<br>::",$forumset->getString('prispevky'),"submissions";
   9         if ($forumset->getString('new')) echo "<br>::><font color='red'>".$forumset->getString('new')." NEW</font>";
  10         echo "<br><br>";
  11 }
  12 ?>