$db->free_result($sub_result);
} while ($num_rows > 0);
$query = "UPDATE search_result SET pid = 0 WHERE NOT EXISTS (SELECT 1 FROM search_temp__1 WHERE search_temp__1.sym_id = search_result.pid)";
$db->send_query($query);
$query = "DROP TEMPORARY TABLE IF EXISTS search_temp__1";
$db->send_query($query);
$query = "DROP TEMPORARY TABLE IF EXISTS search_temp__2";
$db->send_query($query);
$tree = new TreeView($rubric_id, "search_result");
$static_tree = true;
$symptomtree = $tree->build_symptomtree($static_tree);
}
$db->free_result($result);
} else {
$tree = new TreeView($rubric_id, $symptoms_tbl);
$symptomtree = $tree->build_symptomtree();
$query = "SELECT COUNT(*) FROM {$symptoms_tbl}";
if ($rubric_id != -1) {
$query .= " WHERE rubric_id = '{$rubric_id}'";
}
$db->send_query($query);
list($sym_count) = $db->db_fetch_row();
$db->free_result();
}
?>
<div id='tree1' class='selection'>
<?php
echo $symptomtree;
?>
</div>
