使用下边这段代码, 可以让你在Druapl中添加一个block(区块), 显示分类列表, 同时还能在分类后边标记上在此分类下的文章数量, 每个分类链接到对应的分类地址. 例如这种效果:
显示指定vid的分类列表:
<?php
$vid = 11; //指定要显示分类的vid
$num_term = 20; //显示的分类数量
$query = "SELECT term_data.tid AS tid, name, COUNT( nid ) AS count
FROM term_data
LEFT JOIN term_node ON term_data.tid = term_node.tid
WHERE term_data.vid=". $vid ."
GROUP BY tid ORDER BY name ASC LIMIT ". $num_term;
$result = db_query($query);
while ($term = db_fetch_object($result)) {
$items[]= l($term->name, "taxonomy/term/$term->tid") . '(' . $term->count . ')';
}
if(
count($items)) {
return theme('item_list',$items);
}
?>不显示文章数为0的分类:
<?php
$vid = 11; //指定要显示分类的vid
$num_term = 20; //显示的分类数量
$query = "SELECT term_data.tid AS tid, name, COUNT( nid ) AS count
FROM term_data
LEFT JOIN term_node ON term_data.tid = term_node.tid
WHERE term_data.vid=". $vid ."
GROUP BY tid ORDER BY name ASC LIMIT ". $num_term;
$result = db_query($query);
while ($term = db_fetch_object($result)) {
if ($term->count > 0) {
$items[]= l($term->name, "taxonomy/term/$term->tid") . ' (' . $term->count . ')';
}
}
if(
count($items)) {
return theme('item_list',$items);
}
?>
添加新评论