$_tagsurl=''; $_sql=$empire->query("select a.*,b.id from {$dbtbpre}enewstags a join {$dbtbpre}enewstagsdata b on a.tagid = b.tagid where b.id ='$r[id]'"); while($_tag=$empire->fetch($_sql)){ $_tagsurl.='<a href="/tags/'.$_tag[tagid].'.html">'.$_tag[tagname].'</a>'; }