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

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

我得到了答案。下面的代码对我有用。&nbsp;$selCompanyNav2 = mysql_query(&nbsp; &nbsp;"SELECT c.*,r.`term_id`,AVG( r.post_rate_value ) AS rate_value&nbsp; FROM tbl_company AS c&nbsp;&nbsp; &nbsp; INNER JOIN tbl_rating AS r INNER JOIN clewin_posts AS p ON r.`term_id`=c.`term_id`&nbsp;&nbsp; &nbsp; AND r.post_ID=p.ID&nbsp;&nbsp; &nbsp; AND p.post_status='publish'&nbsp;&nbsp; &nbsp; AND c.company_id NOT IN(14,15,16)&nbsp;&nbsp; &nbsp; GROUP BY r.term_id&nbsp;&nbsp;&nbsp; &nbsp; ORDER BY rate_value DESC ");