Joining queries

[russelburgraymond]

Ok here is one I have been trying to figure out. I am writing a script to go along with some forums.  basically I want to get a post and then do a LIKE search for a certain string in all other posts that are not in that topic or several other forums that are on the board here is what I got so far.

 

    $query = "SELECT * FROM ibf_posts,ibf_topics WHERE (ibf_posts.post LIKE '%$link%') && (ibf_posts.forum_id != $tid) && (ibf_topics.forum_id != '4') && (ibf_topics.forum_id != '4') && (ibf_topics.forum_id != '98') && (ibf_topics.forum_id != '97') && (ibf_topics.forum_id != '130') && (ibf_topics.forum_id != '4') && (ibf_topics.forum_id != '129') && (ibf_topics.forum_id != '127') && (ibf_topics.forum_id != '128') LIMIT 6";
    $result = mysql_query($query) or die("oops" . mysql_error());
    while ($row = mysql_fetch_array($result))
    {
        extract($row);
        if ($count == 3)
        {
            echo "<br />";
            $count = 0;
        }
        echo "<a href=\"$boardurl/index.php?showtopic=$topic_id\" target=\"_blank\">$topic_id</a>,";
        $count = $count + 1;
    }

 

 

But unfortunately all it does is return the topic of the post it is currently checking 6 times. What am I doing wrong?