"; echo "List of Registered Participants"; $dotaz = "select * from ".SQL_TBL." where reg_date is not NULL and (cancel='no' or cancel is NULL) order by family_name collate utf8_unicode_ci, first_name collate utf8_unicode_ci"; echo "
\n"; echo "\n";
echo "(".Date("d. m. Y")." at ".Date("H:i:s")."; ";
do {
include "./func/dbconnect.php";
// echo "dotaz: $dotaz
\n"; $vysledek = mysql_query($dotaz); $pocet = MySQL_Num_Rows($vysledek); echo "number of participants: ".$pocet.")\n"; echo "
\n"; $vysledek = mysql_query($dotaz); $pocet = MySQL_Num_Rows($vysledek); echo "number of participants: ".$pocet.")\n"; echo "
\n"; $pismeno_en = ""; echo "
\n";
echo "\n";
while ($zaznam = MySQL_Fetch_Array($vysledek)):
$reg = $zaznam["reg"];
$first_name = $zaznam["first_name"];
$family_name = $zaznam["family_name"];
$institution1 = $zaznam["institution1"];
$institution2 = $zaznam["institution2"];
$street = $zaznam["street"];
$town = $zaznam["town"];
$country = $zaznam["country"];
mb_internal_encoding("UTF-8");
// echo mb_internal_encoding();
// $prvni = mb_substr($family_name,0,1);
$prvni = mb_substr($family_name,0,1);
$first = strtoupper(mb_substr($family_name,0,1));
$first_en = cztoen($first);
$familyn = mb_substr($family_name, 1);
if($pismeno_en!=$first_en):
$pismeno_en = $first_en;
echo "
\n
\n";
MySQL_Close($spojeni);
} while(false);
?>
$first_name $first$familyn \n"; else: $pismeno_en = $first_en; echo " |
$first_name $family_name \n"; endif; echo "("; if(strlen($institution1)>1) { echo $institution1.", ";} if(strlen($town)>1) {echo $town.", ";} echo $country. ") |