|
1 ) { ?>
:
>
$row[gedcom]\n"; } ?>
$text[nosurname]
"; else { $urlfirstchar = urlencode($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]); $linkstr2col1 .= "
$surname[firstchar]
($surname[lncount])
\n"; } } else { if( $surname[firstchar] == "" ) $linkstr2col2 .= "
$text[nosurname]
($surname[lncount])
\n"; else { $urlfirstchar = urlencode($surname[firstchar]); $linkstr2col2 .= "
$surname[firstchar]
($surname[lncount])
\n"; } } $namectr++; } mysql_free_result($result); } $query = "SELECT ucase(lastname) as lastname, ucase( binary(lastname) ) as binlast, count( ucase( lastname ) ) as lncount FROM $people_table $wherestr GROUP BY binlast 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[lastname]
($surname[lncount])
"; } else { if( $surname[lastname] == "" ) $linkstr3col2 .= "$count.
$text[nosurname]
($surname[lncount])
\n"; else $linkstr3col2 .= "$count.
$surname[lastname]
($surname[lncount])
"; } $count++; } mysql_free_result($result); } ?>
:
()
$text[byoccurrence] ($text[totalnames]):"; ?>
|