" . xmlcharacters("$text[surnamelist]$treestr") . "" ); tng_header( $text[surnamelist], $flags ); ?>

 


1 ) { echo getFORM( "surnames", "GET", "form1", "form1" ); echo "$text[tree]: "; echo treeDropdown($treeresult); ?>
$text[nosurname]"; else { $urlfirstchar = urlencode($surname[firstchar]); if($charset == "UTF-8") $surname[firstchar] = utf8_encode($surname[firstchar]); $linkstr .= "$surname[firstchar]"; } $initialchar++; } mysql_free_result($result); } $query = "SELECT ucase(left(lastname,1)) as firstchar, ucase( $binary left(lastname,1) ) as binfirstchar, count( ucase( left( lastname,1) ) ) as lncount FROM $people_table $wherestr GROUP BY binfirstchar ORDER by lncount DESC"; $result = mysql_query($query) or die ("$text[cannotexecutequery]: $query"); if( $result ) { $namectr = 0; while( $surname = mysql_fetch_assoc( $result ) ) { if( $namectr <13 ) { if( $surname[firstchar] == "" ) $linkstr2col1 .= "$text[nosurname] ($surname[lncount])
\n"; else { $urlfirstchar = urlencode($surname[firstchar]); if($charset == "UTF-8") $surname[firstchar] = utf8_encode($surname[firstchar]); $linkstr2col1 .= "$surname[firstchar] ($surname[lncount])
\n"; } } else { if( $surname[firstchar] == "" ) $linkstr2col2 .= "$text[nosurname] ($surname[lncount])
\n"; else { $urlfirstchar = urlencode($surname[firstchar]); if($charset == "UTF-8") $surname[firstchar] = utf8_encode($surname[firstchar]); $linkstr2col2 .= "$surname[firstchar] ($surname[lncount])
\n"; } } $namectr++; } mysql_free_result($result); } $query = "SELECT ucase( $binary TRIM(CONCAT_WS(' ',lnprefix,lastname) ) ) as lastname, TRIM(CONCAT_WS(' ',lnprefix,lastname) ) as lowername, count( ucase($binary lastname ) ) as lncount FROM $people_table $wherestr GROUP BY lastname ORDER by lncount DESC LIMIT 25"; $result = mysql_query($query) or die ("$text[cannotexecutequery]: $query"); if( $result ) { $count = 1; while( $surname = mysql_fetch_assoc( $result ) ) { $surname2 = urlencode($surname[lastname]); if( $count <=13 ) { if( $surname[lastname] == "" ) $linkstr3col1 .= "$count. $text[nosurname] ($surname[lncount])
\n"; else $linkstr3col1 .= "$count. $surname[lowername] ($surname[lncount])
"; } else { if( $surname[lastname] == "" ) $linkstr3col2 .= "$count. $text[nosurname] ($surname[lncount])
\n"; else $linkstr3col2 .= "$count. $surname[lowername] ($surname[lncount])
"; } $count++; } mysql_free_result($result); } ?>


  • $text[byoccurrence] ($text[totalnames]):"; ?>