Thread Getter/News code help (bbcode help)

[GuppyWithAGun]

Ok i was able to fix the problem i was having above with the news not posting with the right title. you can see what i mean at this url http://gamersassault.net/bf2 Now i am getting errors that say this:

 

Warning: mysql_query(): 7 is not a valid MySQL-Link resource in homeguppypublic_htmlbf2forumsincludesdb_mysql.php on line 212

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in homeguppypublic_htmlbf2forumsincludesdb_mysql.php on line 357

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in homeguppypublic_htmlbf2forumsincludesdb_mysql.php on line 358

And here is the code i am using now

<?php
chdir("./forums/"); 
define('NO_REGISTER_GLOBALS', 1); 
define('LOCATION_BYPASS', 1); 
define('SESSION_BYPASS', 1);
include('./global.php');    
chdir("../"); 
?>

<?php

$connection = mysql_connect("localhost","________","_______") or die ("Cannot connect to server.");
$db = mysql_select_db("________", $connection) or die ("Could not select database.");
$sql = "SELECT * FROM thread WHERE forumid='192' 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"];

$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)) {

   $ptext = $row2["pagetext"];

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

$dateposted = date("j M Y",$dateline);
$ptext = nl2br (strip_tags ($row2['pagetext'], '<a><b><i><u><img><center>'));

if ($replycount==1) {

 $commenttext = "Comment";

 }

else {

 $commenttext = "Comments";

 }

require_once("http://gamersassault.net/forums/includes/functions_bbcodeparse.php");
$newscode=parse_bbcode2($ptext,"1","1","1","1","1");

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

echo "<table border=\"0\" width=\"100%\" bgcolor=\"#BFBFBF\" cellspacing=\"1\">
<tr>
<td width=\"70%\" bgcolor=\"#EFC99C\"><a href=\"\forums/showthread.php?threadid=$threadid\"><font color=\"#333333\" 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\">$newscode</td>
</tr>
<tr>
<td bgcolor=\"#EFC99C\" cellspacing=\"1\" height=\"19\"><font face=\"verdana\" size=\"1\" color=\"#333333\"><div align=\"right\"><a href=\"\forums/showthread.php?threadid=$threadid\"><B> $replycount</B> Comments</a>. Last comment by <B>$lastposter</B></div></td></tr></table><br>";

}

}

echo "";

mysql_free_result($sql_result);
mysql_close($connection);

?>