<?php 
$db = JFactory::getDbo(); 
$db->setQuery("SELECT COUNT(*) FROM #_k2_tags_xref WHERE tagID = YOUR_TAG_ID"); 
$result = $db->loadResult(); 
?> 

<?php
/**
 * @version		2.6.x
 * @package		K2
 * @author		JoomlaWorks https://www.joomlaworks.net
 * @copyright	Copyright (c) 2006 - 2014 JoomlaWorks Ltd. All rights reserved.
 * @license		GNU/GPL license: http://www.gnu.org/copyleft/gpl.html
 */

// no direct access
defined('_JEXEC') or die;

?>

<?php $colNumber = 0; ?>

<div id="k2ModuleBox<?php echo $module->id; ?>" class="k2TagCloudBlock<?php if($params->get('moduleclass_sfx')) echo ' '.$params->get('moduleclass_sfx'); ?>">
	<?php foreach ($tags as $tag): ?>
		<?php if(!empty($tag->tag)): ?>
			<?php
				$path = "images/pix/categories/";													// path do 'category' image directory
				$default_img = $path . "default.png";												// name of picture to display for categories without image dedicated
	
				$polishChars = array('ą', 'ć', 'ę', 'ł', 'ń', 'ó', 'ś', 'ż', 'ź');
				$replace     = array('a', 'c', 'e', 'l', 'n', 'o', 's', 'z', 'z');
				$img = mb_strtolower($tag->tag, 'UTF-8');
				$img = str_replace($polishChars, $replace, $img);								// get rid of polish accents
				$img = $path . strtolower(str_replace(" ", "_", $img)) . ".png";			// exchange spaces to '_' & make lowercase
				if (!file_exists($img))
					$img = $default_img;
			?>
			
			<?php if ($colNumber % 3 == 0) echo "<div class=\"singleTagRow\">"; ?>
				<div class="singleTag">
					<a href="<?php echo $tag->link; ?>" style="font-size:<?php echo $tag->size; ?>%" title="<?php echo $tag->count.' '.JText::_('K2_ITEMS_TAGGED_WITH').' '.K2HelperUtilities::cleanHtml($tag->tag); ?>">
						<div class="singleTagImg"> <img src="<?php echo $img; ?>"> </div>
						<div class="singleTagTxt"> <?php echo $tag->tag; ?> (<?php echo $tag->count; ?>) </div>
					</a>
				</div>
			<?php if ($colNumber++ % 3 == 2) echo "</div>"; ?>
		<?php endif; ?>
	<?php endforeach; ?>
	<?php if (($colNumber-1) % 3 !=2) echo "</div>"; ?>
	<div class="clr"></div>
</div>
	<hr id="companiesListHR">