Logo

Development of Materials Science in Research and Education

September 9-13, 2013
"; 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"; $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"; echo "\n"; endwhile; echo "
 
$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. ")
\n
\n"; MySQL_Close($spojeni); } while(false); ?>