cogmios

Ok, no reply, I came up with the following that actually works (in case anyone is looking for it):

function get_related_tags($tagname) {
		global $wpdb;
		$sqlstring="select name from $wpdb->terms where term_id in (" .
   	"select term_id from $wpdb->term_taxonomy where taxonomy=\"post_tag\" and term_taxonomy_id in (" .
   	"select distinct term_taxonomy_id from $wpdb->term_relationships where object_id in (" .
   	"select object_id from $wpdb->term_relationships where term_taxonomy_id =" .
   	"(select term_taxonomy_id from $wpdb->term_taxonomy where term_id=" .
   	"(select term_id from $wpdb->terms where name=\"".$tagname."\")))))";
		$tagidarray = $wpdb->get_col($sqlstring,0);
		$returnRelatedTagDiv='';
		foreach($tagidarray as $relatedtag) {
			if ($relatedtag != $tagname) {
	  			$returnRelatedTagDiv .= "<a href=\"/about/" . $relatedtag . "\">";
	  			$returnRelatedTagDiv .= $relatedtag;
	  			$returnRelatedTagDiv .= "</a> ";
				$tagid = fetch_tag_id($relatedtag);
				//$returnRelatedTagDiv .= fetch_tag_amount($tagid);
				$returnRelatedTagDiv .= "";
			}
		}
		return $returnRelatedTagDiv;
	 }

as documented on http://edward.de.leau.net/wordpress-retrieve-the-set-of-tags-used-with-another-tag-20081110.html

This is actually a hefty query so I wonder if it can be done better.

Another thing… what would happen if I click a tag. then I come to the tag page of the tag with ALL postings. However I would then like to come to the tag page archive of the tag but with only the postings of the tag that I clicked on before… does anyone understand?

A sort of refining query on tags.

It’s the same question a and b for categories. They are a taxonomy term too.

ok … $tag_id = intval( get_query_var(‘tag_id’) ); gives me the current tag id…. now the only thing is to get the correct term that belongs to this id, that should be in there somewhere?

In other words if the following function somehow somewhere exists already:

$file = $_SERVER[“SCRIPT_NAME”];
$break = Explode(‘/’, $file);
$pfile = $break[count($break) – 1];
$pfile = substr($pfile,4);
$pfile = substr($pfile,0,strlen($pfile)-4);
echo $pfile;

Normal tag templates e.g. “tag-synology.php” = “http://myweblog/about/synology” (where i default replaced /tag/ with /about/).

*urgh* found the problem, sorry.