以下是代码例子。
复制代码 代码如下:
$nid = $row->nid;
$country = db_result(db_query('SELECT name FROM {term_data} term_data JOIN {term_node} term_node ON term_node.tid = term_data.tid WHERE term_data.vid = %d AND term_node.nid = %d', 1, $nid));
$investment = db_result(db_query('SELECT name FROM {term_data} term_data JOIN {term_node} term_node ON term_node.tid = term_data.tid WHERE term_data.vid = %d AND term_node.nid = %d', 2, $nid));
?>
