My Tag Cloud
categories”;
$cats = $wpdb->get_results($qrystr); // Default output type: object
// Initialize each category post counter to zero
// Save category info as an array of objects
foreach ($cats as $cat)
{
$catcnt[$catid]->cat_ID = $cat->cat_ID;
$catcnt[$catid]->cat_name = $cat->cat_name;
$catcnt[$catid]->postcnt = 0;
}
// Grab the post-to-category info from table wp_post2cat
$qrystr2 = “SELECT post_id, category_id from $wpdb->post2cat”;
$post2cats = $wpdb->get_results($qrystr2);
// Now count the number of posts for each category
foreach ($post2cats as $post2cat)
{
// You could do the following in one line, but I’ve
// done it in two for clarity.
//
$pcatid = $post2cat->category_id;
$catcnt[$pcatid]->postcnt += 1;
}
// Now output the tag cloud
echo ‘
foreach ($catcnt as $catinfo)
{
$catname = $catinfo->cat_name;
$catlink = get_category_link($catinfo->cat_ID);
$postcnt = $catinfo->postcnt;
echo ‘‘;
echo $catname,” “;
}
echo “
“;
?>
