[GuppyWithAGun]

Will this work? or am i way off?

<?php

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

$db = mysql_select_db("db_name", $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"];


if ("$bericht");

{

	$bericht = nl2br(strip_tags ($row['pagetext'], '<a><b><i><u><img><center>'));
 	$bericht = preg_replace ( "/\[img\](.+?)\[\/img\]/", "<img src=\"$1\" />", $bericht );
 	$bericht = preg_replace ( "/\[url\=(.+?)\](.+?)\[\/url\]/", "<a href=\"$1\" target=\"_blank\">$2</a>", $bericht );
 	$bericht = preg_replace ( "/\[move\](.+?)\[\/move\]/", "<marquee>$1</marquee>", $bericht );
 	$bericht = preg_replace ( "/\[b\](.+?)\[\/b\]/", "<b>$1</b>", $bericht );
	$bericht = preg_replace ( "/\[i\](.+?)\[\/i\]/", "<i>$1</i>", $bericht );

}

$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>'));

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 "";


?>