Directory

function getChildTerms($parent, $vid)
{
$sql = “select td.tid, td.vid, td.name”
. ” from term_data td”
. ” join term_hierarchy th on th.tid = td.tid”
. ” where th.parent = $parent”
. ” and td.vid = $vid”
. ” order by td.weight, td.name”;
$terms = db_query($sql);
$output = “”;
while ($aterm = db_fetch_object($terms))
{
$output .= “

\n”
. getChildTerms($aterm->tid, $vid);
}
return ($output != “”)? “

\n” . $output . “

\n” : “”;
}

$sql = “select vid, name from vocabulary where name in (‘directory’) order by name”;
$vocabularies = db_query($sql);
$output = “”;
while ($avoc = db_fetch_object($vocabularies))
{
$output .= getChildTerms(0, $avoc->vid);
}
print “

\n”;

?>

function getChildTerms($parent, $vid)
{
$sql = “select td.tid, td.vid, td.name”
. ” from term_data td”
. ” join term_hierarchy th on th.tid = td.tid”
. ” where th.parent = $parent”
. ” and td.vid = $vid”
. ” order by td.weight, td.name”;
$terms = db_query($sql);
$output = “”;
while ($aterm = db_fetch_object($terms))
{
$output .= “

\n”
. getChildTerms($aterm->tid, $vid);
}
return ($output != “”)? “

\n” . $output . “

\n” : “”;
}

$sql = “select vid, name from vocabulary where name in (‘directory’) order by name”;
$vocabularies = db_query($sql);
$output = “”;
while ($avoc = db_fetch_object($vocabularies))
{
$output .= getChildTerms(0, $avoc->vid);
}
print “

\n”;

?>