$database=JFactory::getDBO();$database->setQuery('select count(*) as `cnt`, `warehouse` as `title` from Inspection_Findings group by `warehouse`');$a = $database->loadObjectList();
$url .= '&chl=';foreach ($a as $value) $url .= urlencode($value->title).'|';$url = substr($url, 0, strlen($url)-1);
$url .='&chd=t:';foreach ($a as $value) $url .= $value->cnt.',';$url = substr($url, 0, strlen($url)-1);
echo '<img src ="'.$url.'" />';