Miscellany

<h1>Tags på Juiced.no</h1>


<?php

$query = "SELECT sokeord AS tag, COUNT(sokeord) AS quantity
  FROM jc_allesokeord
  GROUP BY sokeord
  ORDER BY sokeord ASC";

$result = $sql->query($query);

while ($row = mysql_fetch_array($result)) {

    $tags[$row['tag']] = $row['quantity'];
}

$max_size = 250;
$min_size = 100;

$max_qty = max(array_values($tags));
$min_qty = min(array_values($tags));

$spread = $max_qty - $min_qty;
if (0 == $spread) { 
    $spread = 1;
}

$step = ($max_size - $min_size)/($spread);

foreach ($tags as $key => $value) {

    $size = $min_size + (($value - $min_qty) * $step);

    echo '<a href="#" style="font-size: '.$size.'%"';
    echo ' title="'.$value.' tagget med '.$key.'"';
    echo '>'.$key.'</a> ';
}

?>