Totally confused (Needs help)

[Chris M]

Here is a quick & basic clean-up of your code:

PHP Code:

<?php 
connectTOforum();
 
$query = mysql_query("SELECT * from thread WHERE forumid='2' ORDER BY threadid DESC LIMIT 0, 5");
while($row = mysql_fetch_array($query)){ 
 
    $date = date('m-d-y', $row['dateline']);
    $time = date('g:iA', $row['dateline']);
 
$query2 = mysql_query("SELECT * from post WHERE threadid='$row[threadid]' ORDER BY 'threadid' DESC LIMIT 1");
    $info2  = mysql_fetch_array($query2);
$comment = htmlentities($info2[pagetext]);
    $comment = str_replace ("\n", "<br/>", "$comment");
    $find = array(
    "'\[b\](.*?)\[/b\]'is",
    "'\[i\](.*?)\[/i\]'is",
    "'\[u\](.*?)\[/u\]'is",
    "'\[size=(.*?)\](.*?)\[/size\]'is",
    "'\[color=(.*?)\](.*?)\[/color\]'is",
    "'\[img\](.*?)\[/img\]'is",
    "'\[url\](.*?)\[/url\]'is",
    "'\[url=(.*?)\](.*?)\[/url\]'is");
    $replace = array(
    "<b>\\1</b>",
    "<i>\\1</i>",
    "<u>\\1</u>", 
    "<font size=\"\\1\">\\2</font>",
    "<font color=\"\\1\">\\2</font>",
    "<img src=\"/tutorials/thumbnail.php?url=\\1&width=460\" class=\"link\">", 
    "<a href=\"\\1\" class=\"link\">\\1</a>", 
    "<a href=\"\\1\" class=\"link\">\\2</a>");
 
    while(
    (preg_match("'\[b\](.*?)\[/b\]'is",$comment)) || 
    (preg_match("'\[i\](.*?)\[/i\]'is",$comment)) || 
    (preg_match("'\[u\](.*?)\[/u\]'is",$comment)) || 
    (preg_match("'\[size=(.*?)\](.*?)\[/size\]'is",$comment)) ||
    (preg_match("'\[color=(.*?)\](.*?)\[/color\]'is",$comment)) || 
    (preg_match("'\[img\](.*?)\[/img\]'is",$comment)) || 
    (preg_match("'\[url\](.*?)\[/url\]'is",$comment)) || 
    (preg_match("'\[url=(.*?)\](.*?)\[/url\]'is",$comment))) {
    $comment = preg_replace($find,$replace,$comment);
    }
?>    
 
<div class="post">
<h3><span class="date"><?php echo "$date"; echo ","; echo "$time"; ?></span><?php echo "$row['title']"; ?></h3>
        <div class="content">
            <?php echo "$comment"; ?>
            <div class="post-foot">
                <a href="http://www.siteaddress.com/forum/showthread.php?threadid=<?php $row[threadid] ?>" class="link">Comments</a>(<strong><?php echo "$row[replycount]"; ?></strong>)</td>
            </div>
        </div>
    </div>
<?php } ?>

Chris