Show posts instead of threads... HELP!!!!!

<?php
error_reporting(7);
require('./global.php');

  $news = $DB_site->query("SELECT thread.title, thread.threadid, thread.iconid, thread.postusername, thread.replycount FROM thread WHERE thread.forumid = XX ORDER BY thread.threadid DESC LIMIT 5");
  print("<table width='95%' align='center' cellspacing=0>");
  $lastdate="";
  while($new=$DB_site->fetch_array($news)) {
    $newstext=$DB_site->query_first("
    SELECT post.pagetext, post.dateline FROM post
    WHERE post.threadid='$new[threadid]'
    ORDER BY postid LIMIT 5
    ");
  
    print("<tr>");
//if(date("d.m.Y",$newstext[dateline])!=$lastdate) {
  //print(date("d.m.Y",$newstext[dateline])); }

$lastdate=date("d.m.Y",$newstext[dateline]);

    print("<th class='head' align='left' bgcolor='#FFFFFF".$headcolor."'><font size=1>".date("d.m.Y - H:i:",$newstext[dateline])."</font><br>".$new[title]."</th>");
    print("<th class='head' align='right' bgcolor='#FFFFFF".$headcolor."'>".$new[postusername]."<br><font size=1><a href='http://some forums/showthread.php?s=&threadid=".$new[threadid]."'>Comments(".$new[replycount].")</a></font></th></tr>");
    print("<tr></tr><tr><td class=news colspan='2' bgcolor='#FFFFFF".$newscolor."'>".bbcodeparse2($newstext[pagetext],1,1,1,1)."</td>");
    print("</tr><tr><td height=5></td></tr>");
  }
  print("</table>");
?>

how to change the above script to show posts in one of the threads instead of threads in the forums ??

[Xenon]

perpage viewings isn't that easy, but possible, too
just play around with the limit tag of mysql

[DrkFusion]

Wow, this looks very useful in my case. Would I be able to receive the code...unless that is that above

If it is, may I have permission to use it?

[Xenon]

Arunan, of course you can get it and use it.
but it's just a little newsgrapper to get the news out of the db, not very special, and i think it wasn't coded perfectly, it just fits my needs for my site

but if you want it, ask per pm again so i cant forget

[ViPeR-GtS]

Xenon: some question to ask...

how to auto logout after you have post a reply and redirect back to the non vb page ???

and the login cant seems to work... does it need to be in the same folder as the forums files ???

[Xenon]

the autologout is after 15 minutes...
that's why cookietimeout is there.

for redirect just change the redirect link.