Our Faculty has a partnership with more than 60 universities from EU countries, USA, Mexico, East and South East Asia. Thanks to its amazing location in the heart of Europe, we are a great place for students from all over the world.
$name
";
}
else {
echo "
$name
";
}
?>
=0 AND Language=1) AND (IDDivision=$sup) ORDER BY Important DESC,InsertDate DESC";
$result= ksa_query_db($dotaz);
$num_rows=sizeof($result); //počet záznamů
if ($num_rows>0)
echo "
";
}
}
}
/*
$data = ksa_query_db("select DISTINCT worker.IDWorker, worker.TitleBefore, worker.Name, worker.Surname, worker.TitleAfter, worker.Email, worker.JobPhone, worker.User from works left join position on (position.idposition = works.IDPosition) left join worker on (works.IDWorker = worker.IDWorker) where ($where) && (position.View = 1 && position.IDposition = 21 || position.IDposition = 13) order by worker.Surname, worker.Name");
if (sizeof($data)!=0)echo "
";
$where="(works.IDDivision = $sup) AND ((works.IDPosition=51) )";
$data1 = ksa_query_db("select DISTINCT worker.IDWorker, worker.TitleBefore, worker.Name, worker.Surname, worker.TitleAfter, worker.Email, worker.JobPhone, worker.User,works.IDPosition from works left join position on (position.IDPosition = works.IDPosition) left join worker on (works.IDWorker = worker.IDWorker) where ($where) && position.View = 1 order by position.Hiearchy DESC,worker.Surname, worker.Name");
echo "\n
";
for($i=0;$i
";
//echo "adresy".$adress1." ".$adress2;
$adress = ksa_query_db("select Street, Town , PostalCode from adress where IDAdress=$adress1 or IDAdress=$adress2 ORDer by Street DESC");
//echo "IDAdress=$adress1 or IDAdress=$adress2";
if (sizeof($adress)>0){
echo "
";
echo "";
echo "";
echo "";
echo "$name
";
for($i=0;$i";
echo $adress[$i][0].", ";
echo $adress[$i][2]." ";
echo $adress[$i][1]." ";
echo "";
echo " ";
echo "";
}
echo "";
echo "Phone: ".$phoneprefix.$phone." ";
if ($email!="")
echo "Email: ".$email." ";
//echo " Orientační plán budov FEK v Chebu ";
//echo " Orientační plán budov ZČU v Plzni ";
}
}
?>
