//print_r($data);
$_tid= $data->node_data_field_meetws_year_field_meetws_province_value;
$result = db_query("SELECT aa.tid, aa.name FROM {term_hierarchy} bb LEFT JOIN {term_data} aa ON bb.parent = aa.tid WHERE bb.tid = $_tid");
$_rs = db_fetch_object($result);
$result2 = db_query("SELECT t.tid, t.name FROM {term_data} t LEFT JOIN {term_hierarchy} b ON t.tid = b.tid WHERE b.parent = " . $_rs->tid);
$items = '';
while ($_rs2 = db_fetch_object($result2)) {
if( $_rs2->tid == $_tid)
$items .= "" . trim($_rs2->name) . "";
else
$items .= trim($_rs2->name);
}
echo "" . $_rs->name . "(" . $items . ")";
?> |
//print_r($data);
$_tid= $data->node_data_field_meetws_year_field_meetws_province_value;
$result = db_query("SELECT aa.tid, aa.name FROM {term_hierarchy} bb LEFT JOIN {term_data} aa ON bb.parent = aa.tid WHERE bb.tid = $_tid");
$_rs = db_fetch_object($result);
$result2 = db_query("SELECT t.tid, t.name FROM {term_data} t LEFT JOIN {term_hierarchy} b ON t.tid = b.tid WHERE b.parent = " . $_rs->tid);
$items = '';
while ($_rs2 = db_fetch_object($result2)) {
if( $_rs2->tid == $_tid)
$items .= "" . trim($_rs2->name) . "";
else
$items .= trim($_rs2->name);
}
echo "" . $_rs->name . "(" . $items . ")";
?> |
//print_r($data);
$_tid= $data->node_data_field_meetws_year_field_meetws_province_value;
$result = db_query("SELECT aa.tid, aa.name FROM {term_hierarchy} bb LEFT JOIN {term_data} aa ON bb.parent = aa.tid WHERE bb.tid = $_tid");
$_rs = db_fetch_object($result);
$result2 = db_query("SELECT t.tid, t.name FROM {term_data} t LEFT JOIN {term_hierarchy} b ON t.tid = b.tid WHERE b.parent = " . $_rs->tid);
$items = '';
while ($_rs2 = db_fetch_object($result2)) {
if( $_rs2->tid == $_tid)
$items .= "" . trim($_rs2->name) . "";
else
$items .= trim($_rs2->name);
}
echo "" . $_rs->name . "(" . $items . ")";
?> |
//print_r($data);
$_tid= $data->node_data_field_meetws_year_field_meetws_province_value;
$result = db_query("SELECT aa.tid, aa.name FROM {term_hierarchy} bb LEFT JOIN {term_data} aa ON bb.parent = aa.tid WHERE bb.tid = $_tid");
$_rs = db_fetch_object($result);
$result2 = db_query("SELECT t.tid, t.name FROM {term_data} t LEFT JOIN {term_hierarchy} b ON t.tid = b.tid WHERE b.parent = " . $_rs->tid);
$items = '';
while ($_rs2 = db_fetch_object($result2)) {
if( $_rs2->tid == $_tid)
$items .= "" . trim($_rs2->name) . "";
else
$items .= trim($_rs2->name);
}
echo "" . $_rs->name . "(" . $items . ")";
?> |