Ok, dafür venwende ich folgendes:ebene 2 kann man als verbindung nochmal links gehighlightet darstellen,
Kategoriename
Output
Code: Alles auswählen
<?php
$sql = "SELECT
name,parentid
FROM
".$cfg["tab"]["cat_tree"]." AS A,
".$cfg["tab"]["cat"]." AS B,
".$cfg["tab"]["cat_lang"]." AS C
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
C.idlang='$lang' AND
B.idclient='$client' AND
B.idcat ='$idcat' AND
B.parentid != 0";
$db->query($sql);
$db->next_record();
$pid = $db->f('parentid');
if ($pid != 1) {
echo '<h1><img src="textmaker/text.php?text='.urlencode($db->f('name')).'&s=12"></h1>';
} else {
$sql = "SELECT
C.name,
B.parentid
FROM
".$cfg["tab"]["cat_tree"]." AS A,
".$cfg["tab"]["cat"]." AS B,
".$cfg["tab"]["cat_lang"]." AS C,
".$cfg["tab"]["cat"]." AS D1,
".$cfg["tab"]["cat_lang"]." AS D2
WHERE
A.idcat=B.idcat AND
B.idcat=C.idcat AND
C.idlang='$lang' AND
B.idclient='$client' AND
B.idcat ='$idcat' AND
B.parentid != 0 AND
D1.parentid = A.idcat AND
D2.idcat = D1.idcat AND
D2.public =1
LIMIT 1";
$db->query($sql);
if( $db->next_record() )
echo '<h1>'.urlencode($db->f('name')).'</h1>';
}
?>