'; print ''; print 'http://www.stolpaaos.dk/forum/'; print 'StolPaaOs.dk\'s forum'; include 'dbconnect.php'; if ($_GET['16c'] == '1') { $query="SELECT *, DATE_FORMAT(date,'%W %d-%m-%Y kl. %H:%i') AS FormDate FROM Entries WHERE ((spam ='0') AND (forumid ='13')) ORDER BY id DESC Limit 10"; } else { $query="SELECT *, DATE_FORMAT(date,'%W %d-%m-%Y kl. %H:%i') AS FormDate FROM Entries WHERE ((spam ='0') AND ((forumid ='5') OR (forumid ='8') OR (forumid ='10') OR (forumid ='11') OR (forumid ='12') OR (forumid ='14'))) ORDER BY id DESC Limit 10"; } $result=mysql_query($query); $num=mysql_numrows($result); $i=0; while ($i < $num) { $replypostername=mysql_result($result,$i,"name"); $replyposttime=mysql_result($result,$i,"FormDate"); $replycomment=mysql_result($result,$i,"Comment"); $msgid=mysql_result($result,$i,"id"); $replyid=mysql_result($result,$i,"replyid"); $forumid=mysql_result($result,$i,"forumid"); // vi hiver lige første indlæg i tråden frem If ($replyid == 0) { $topic=mysql_result($result,$i,"subject"); } else { $queryfirstpost="SELECT subject FROM Entries WHERE (Id ='$replyid')"; $resultsfirstpost=mysql_query($queryfirstpost); $topic=mysql_result($resultsfirstpost,0,"subject"); } print ''; print '('.$replyposttime.') - '; print '..en eller anden står og hvisker ude bagved.'; } else { print $msgid.') '.$topic.' - '.$replypostername.' - '.$replyposttime.''; print '('.$replyposttime.') - '; print substr(strip_tags(str_replace("\n", "
", $replycomment)), 0, 150).'..'; } print $replyposttime.''; $i++; } mysql_close(); ?>