# ------------------------------------ CALCULATE THE RELATED TAGS --------------------------
if ($roomType=="tag") {
	$arrayInitial= array();
	foreach ($uriTags as $itag) {
		$arrayInitial[$itag]=0;
	}
	# Generate related tags list
	$relatedSql = sprintf(" SELECT t.id, t.tag, m.id, m.tag
			    FROM  taggings AS t , taggings AS m
			    WHERE  m.id = t.id
			    AND t.tag IN (%s) 
			    AND m.tag NOT IN (%s)
			   order by m.tag ", $list, $list);
	$relatedResult=mysql_query($relatedSql,$conn) or die(mysql_error()); 
	$related="";
	$lastTag="///";
	while ($rel = mysql_fetch_array($relatedResult)) { 
		$xtag=$rel[3];
		$keyTag=$rel[1];			
		if ($xtag==$lastTag) {
			$arrayTags[$keyTag]= 1;
			continue;
		} else {
			if ($lastTag<>"///" AND !in_array(0,$arrayTags) ) {
				$related = $related . sprintf('<a href="%stags/%s,%s">%s</a>, ',$host,$tags,$lastTag,$lastTag);}
			$lastTag = $xtag;
			$arrayTags=$arrayInitial;
			$arrayTags[$keyTag]= 1;
		}		
	}
	if ($lastTag<>"///" AND !in_array(0,$arrayTags) ) {
		$related = $related . sprintf('<a href="%stags/%s,%s">%s</a>, ',$host,$tags,$lastTag,$lastTag);}
}