$sql_tags="SELECT * FROM tbltags WHERE tid IN (SELECT tid FROM tbltagproduct WHERE cid=$bid_tag AND pid=0 AND tpstatus=1)";
$result_tags = mysql_query($sql_tags);
echo "
Tags : ";
while($rows_tags = mysql_fetch_array($result_tags))
{
echo $rows_tags['tagname'].", ";
}
echo "
";
?>