$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>