[GuppyWithAGun]

This is what i have now and still no luck... any ideas?

<?php
chdir("./forums/"); 
include('./global.php');    
include('./includes/functions_user.php'); 
chdir("../"); 
?>

<?php

$connection = mysql_connect("localhost","USERNAME","PASSWORD") or die ("Cannot connect to server.");

$db = mysql_select_db("DBNAME", $connection) or die ("Could not select database.");

$sql = "SELECT * FROM thread WHERE forumid='8' ORDER BY threadid DESC LIMIT 7";

$sql_result = mysql_query($sql, $connection) or die ("Could not execute query 1.");


if (!$sql_result) { 

  echo "<p>Could not get record.";

} 

while ($row = mysql_fetch_array($sql_result)) {
   $threadid = $row["threadid"];
   $title = $row["title"];   
   $forumid = $row["forumid"];
   $replycount = $row["replycount"];
   $postusername = $row["postusername"];
   $postuserid = $row["postuserid"];
   $lastposter = $row["lastposter"];
   $iconid = $row["iconid"];
   $dateline = $row["dateline"];
$bericht = nl2br(strip_tags ($row['pagetext'], '<a><b><i><u><img><center>'));

// This parses the bbcode
require_once("forums/includes/functions_bbcodeparse.php");
$bericht=parse_bbcode2($ptext,"1","1","1","1","1");

// Uncomment next 4 lines if you want to limit the amount of text displayed to the first paragraph.
// $trimmed = explode("<br />", $bericht);
// $bericht=$trimmed[0];
// $trimmed = explode("</p>", $bericht);
// $bericht=$trimmed[0];

// This is optional. It strips out unecessary tags if you wish and leaves those specified behind
// $bericht = strip_tags($bericht, '<a>,<b>,<strong>,<i>,<em>,<br />,<br>,<p>');


$sql2 = "SELECT * FROM post WHERE threadid = \"$threadid\" ORDER BY postid ASC LIMIT 1";

$sql_result2 = mysql_query($sql2, $connection) or die ("Could not execute query in second sql statement.");

if (!$sql_result2) { 

  echo "<p>Could not get record in second statement.";

} 



while ($row2 = mysql_fetch_array($sql_result2)) {

   $pagetext = $row2["pagetext"];



$pagetext = nl2br (strip_tags ($row['pagetext'], '<a><b><i><u><img><center>'));



$dateposted = date("j M Y",$dateline);

$pagetext = nl2br (strip_tags ($row2['pagetext'], '<a><b><i><u><img><center>'));



if ($replycount==1) {

 $commenttext = "Comment";

 }

else {

 $commenttext = "Comments";

 }



$bericht = nl2br(strip_tags ($row2['pagetext'], '<a><b><i><u><img><center>'));

// **********************

//Edit the HTML here (keep in mind that any double quote that is HTML requires a backslash in front of it)


echo "<table border=\"0\" width=\"100%\" bgcolor=\"#BFBFBF\" cellspacing=\"1\">
<tr>
<td width=\"70%\" bgcolor=\"#004F7D\"><a href=\"forums/showthread.php?threadid=$threadid\"><font color=\"#FFFFFF\" style=\"font-size: 10px\" face=\"Verdana\">&nbsp;? <B>$title</B> -- $dateposted</td>
</tr>
<tr>
<td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2><font color=\"#FFFFFF\" style=\"font-size: 10px\" face=\"Verdana\">$bericht</td>
</tr>
<tr>
<td bgcolor=\"#004F7D\" cellspacing=\"1\" height=\"19\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\"><div align=\"right\"><B> $replycount</B> Comments. Last comment by <B>$lastposter</B></div></td></tr></table><br>";



}

}



echo "";



mysql_free_result($sql_result);

mysql_close($connection);

?>