我想從這段代碼中排除 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 } ?>
1 回答
翻閱古今
TA貢獻1780條經(jīng)驗 獲得超5個贊
我得到了答案。
下面的代碼對我有用。
$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 "
);
- 1 回答
- 0 關(guān)注
- 105 瀏覽
添加回答
舉報
0/150
提交
取消