| 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')." 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 | ?> |