comparing values

[JD_]

ive had searched on this forum but cant get it to work how i want it no matter what, if anyone can help please do

im trying to compare the topic_id from one table to another and if its found dont display that result atm the code is

in news.php i have

<? for ($i = 0; $i < count($news); $i++) {

?>
html to display posts e.g $news[$i]['topic_id']
<?php

}

?>

in approve.php the other i have

$db = mysql_connect($dbServer, $dbUserName, $dbPassword) or die(mysql_error());
mysql_select_db($dbDatabase, $db) or die(mysql_error()); ?>
<? $aq = "SELECT topic_id FROM approve_posts";
   $ar = mysql_query ($aq) or die('approve SQL Query Failed');
$approve = mysql_fetch_assoc ($ar)
?>

so i basically want if $approve = $news[$i]['topic_id'] then skip that result and display the rest.

[nemonoman]

Post your table definitions. You should be able to do the comparison with one SQL query and print out the acceptable results.

[JD_]

well its bit complicated is phpbb and fetch all ive found a way to i could do it where it actually builds the query

with something like

if ($CFG['posts_approve'])
    {
        $sql .= '
              t.topic_id <> $approve AND';
    }

approve being

$aq = "SELECT topic_id FROM approve_posts";
$ar = mysql_query ($aq) or die('approve SQL Query Failed');
$approve = mysql_fetch_assoc ($ar);

the approve table is name approve_posts and field topic_id