时间戳

首页 > 解决方案 > 我想从此查询中排除一些公司名称

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

问题描述

我想从这段代码中排除 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 } ?>

标签： phpmysql

解决方案

我得到了答案。

下面的代码对我有用。

 $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 "
);

推荐阅读