assign("is_logged","yes"); $main_page -> assign("login",$_SESSION["login"]); } $pol=open_connection(); $main_page -> assign("where","Participants"); mysql_query("SET NAMES \'utf8\'"); mysql_set_charset('utf8',$pol); //echo ">> ".mysql_client_encoding(); $query = "SELECT name, surname,affiliation FROM $db_table WHERE (login!=\"admin\" AND login!=\"test\") ORDER BY surname;"; $res=mysql_query($query) or die ("Wysypał się na $query"); $participants=array(); while($rek=mysql_fetch_array($res)) { $name=$rek[0]; $surname=$rek[1]; //if($surname=="Lukaszewicz") {$surname="Łukaszewicz";} $aff=$rek[2]; $participants[]=array("name"=>$name,"surname"=>$surname,"aff"=>$aff); } $srodek -> assign("participants",$participants); $main_page -> assign("main", $srodek -> fetch("participants.tpl.html")); $main_page -> display("main.tpl.html"); ?>