Topics

Dries gave me some Drupal code to show the topics/tags that I write about and that are used on my website. This will help me keeping my tags clean (or make them cleaner ;-).

What Klaas writes about

$max = db_result(db_query(‘SELECT COUNT(nid) FROM {node}’)); $result = db_query(‘SELECT DISTINCT(td.tid), td.name, COUNT(tn.nid)
AS visits FROM {term_data} td INNER JOIN {term_node} tn ON td.tid =
tn.tid GROUP BY td.tid ORDER BY name’);

while ($term = db_fetch_object($result)) { $weight = round(100 * $term->visits / $max); $size = 10 + round($weight / 1.2); print ” ”. l($term->name, “taxonomy/term/$term->tid”, array (‘style’ => ‘font-size: ‘. $size .‘px; padding: 7px\