Members Genealogy Files D-G

“);
$output .= l(‘<>’,’node/15689′);
$sub_items = array();
// call function to find all nodes in a term
$sub_items = get_nodes_in_term(15,5,1);
$output .= “

“;
$letter = NULL;
// Add nodes to items array
foreach($sub_items as $val) {
$newletter = $val->title{0};
if ($newletter != $letter) {
$output .= “
–$newletter–“;
$letter = $newletter;
}
$output .= “
• ” . l($val->title, “node/$val->nid”) . “

“;
}
$output .= “

“;
$output .= l(‘<>’,’node/15689′);
print $output;

function get_nodes_in_term($tid,$tranches,$trancheno) {
$sub_items = array();
$sql = “SELECT node.title, node.nid FROM node INNER JOIN term_node ON node.nid = term_node.nid WHERE term_node.tid = $tid ORDER BY node.title”;
$result = db_query($sql);
$count = mysql_num_rows($result);
$tranchesize = intval($count/$tranches)+1;
$start = $trancheno*$tranchesize;
$end = $tranchesize+1;
$limitsql = ” LIMIT $start, $end”;
$result = db_query($sql.$limitsql);
while ($anode = db_fetch_object($result)) {
$sub_items[] = $anode;
}
return $sub_items;
}
?>

“);
$output .= l(‘<>’,’node/15689′);
$sub_items = array();
// call function to find all nodes in a term
$sub_items = get_nodes_in_term(15,5,1);
$output .= “

“;
$letter = NULL;
// Add nodes to items array
foreach($sub_items as $val) {
$newletter = $val->title{0};
if ($newletter != $letter) {
$output .= “
–$newletter–“;
$letter = $newletter;
}
$output .= “
• ” . l($val->title, “node/$val->nid”) . “

“;
}
$output .= “

“;
$output .= l(‘<>’,’node/15689′);
print $output;

function get_nodes_in_term($tid,$tranches,$trancheno) {
$sub_items = array();
$sql = “SELECT node.title, node.nid FROM node INNER JOIN term_node ON node.nid = term_node.nid WHERE term_node.tid = $tid ORDER BY node.title”;
$result = db_query($sql);
$count = mysql_num_rows($result);
$tranchesize = intval($count/$tranches)+1;
$start = $trancheno*$tranchesize;
$end = $tranchesize+1;
$limitsql = ” LIMIT $start, $end”;
$result = db_query($sql.$limitsql);
while ($anode = db_fetch_object($result)) {
$sub_items[] = $anode;
}
return $sub_items;
}
?>