Commit | Line | Data |
---|---|---|
bc13d5d6 H |
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 | ?> |