我想从此查询中排除一些公司名称

Question

我想从这段代码中排除 company_id 18... 下面的代码目前正在运行，但有一个问题只显示那些有评级的公司。我想从这个列表中排除一些公司。<?php     //$selCompanyNav2 = mysql_query("select * from tbl_company WHERE status = 'Y' ORDER BY ordering ASC");    $selCompanyNav2 = mysql_query("SELECT c.*,r.`term_id`,avg( r.post_rate_value ) AS rate_value  FROM tbl_company AS c                                     INNER JOIN tbl_rating AS r                                     INNER JOIN clewin_posts AS p ON r.`term_id`=c.`term_id` AND r.post_ID=p.ID AND p.post_status='publish'                                     GROUP BY r.term_id  ORDER BY rate_value DESC ");    $num_resultsNav2= @mysql_num_rows($selCompanyNav2);    if($num_resultsNav2>0){?><ul>    <?php       while($rowNav2 = mysql_fetch_assoc($selCompanyNav2)){          $titleNav2 =$rowNav2['company_name'];        if($rowNav2['alttitle']){ $alttitle2=$rowNav2['alttitle'];}else{$alttitle2=$rowNav2['company_name'];}        $company_seotitleNav2=$rowNav2['company_seotitle'];        ?>        <li>        <a href="<?php bloginfo('wpurl'); ?>/window-companies/<?php echo $company_seotitleNav2;?>/" title=""><?php echo $titleNav2;?></a>        </li>    <?php } ?></ul><?php } ?>

Answer 1

我得到了答案。

下面的代码对我有用。

 $selCompanyNav2 = mysql_query(

   "SELECT c.*,r.`term_id`,AVG( r.post_rate_value ) AS rate_value  FROM tbl_company AS c 

    INNER JOIN tbl_rating AS r INNER JOIN clewin_posts AS p ON r.`term_id`=c.`term_id` 

    AND r.post_ID=p.ID 

    AND p.post_status='publish' 

    AND c.company_id NOT IN(14,15,16) 

    GROUP BY r.term_id  

    ORDER BY rate_value DESC "

);