// Skripta Franci Lajovic, IT Niansis maj 2002 // franci@niansis.com // spremenljivke header('Content-Type: text/html; charset=windows-1250'); if (!ini_get('register_globals')) { $superglobals = array($_SERVER, $_ENV, $_FILES, $_COOKIE, $_POST, $_GET); if (isset($_SESSION)) { array_unshift($superglobals, $_SESSION); } foreach ($superglobals as $superglobal) { extract($superglobal, EXTR_SKIP); } } $last_edit="31.3.2009"; include_once "../inc/inc.php"; $izpis.="
";
if (!$_REQUEST['id']) {
$query="SELECT i.id,i.naziv1,i.naziv2,i.naslov,i.posta,i.posta1,sifP.Kraj,sifD.NazivDrzave FROM izvajalec$leto_db AS i
LEFT JOIN sifPoste AS sifP ON sifP.Posta=i.posta
LEFT JOIN sifDrzave AS sifD ON sifD.Drzava=i.drzava
WHERE aktiven='1' AND status=10 ORDER BY naziv1";
$result=mysql_query($query);
$no=mysql_num_rows($result);
$izpis.="NACIONALNI KOORDINATOR ($no)
";
while($row=mysql_fetch_row($result)){
$test_chr=$row[1]{0};
$test_chr=strtoupper($test_chr);
$izpis.="
$row[1]
";
if ($row[2]) $izpis.= "$row[2]
";
if ($row[4]) $izpis.= "$row[3], $row[4] $row[6]";
else if ($row[5]) $izpis.= "$row[5], $row[7]";
$izpis.="
";
}
$query="SELECT i.id,i.naziv1,i.naziv2,i.naslov,i.posta,i.posta1,sifP.Kraj,sifD.NazivDrzave FROM izvajalec$leto_db AS i
LEFT JOIN sifPoste AS sifP ON sifP.Posta=i.posta
LEFT JOIN sifDrzave AS sifD ON sifD.Drzava=i.drzava
WHERE aktiven='1' AND status=1 ORDER BY naziv1";
$result=mysql_query($query);
$no=mysql_num_rows($result);
$izpis.="OBMOČNI KOORDINATORJI ($no)
";
while($row=mysql_fetch_row($result)){
$test_chr=$row[1]{0};
$test_chr=strtoupper($test_chr);
$izpis.="
$row[1]
";
if ($row[2]) $izpis.= "$row[2]
";
if ($row[4]) $izpis.= "$row[3], $row[4] $row[6]";
else if ($row[5]) $izpis.= "$row[5], $row[7]";
$izpis.="
";
}
$query="SELECT i.id,i.naziv1,i.naziv2,i.naslov,i.posta,i.posta1,sifP.Kraj,sifD.NazivDrzave FROM izvajalec$leto_db AS i
LEFT JOIN sifPoste AS sifP ON sifP.Posta=i.posta
LEFT JOIN sifDrzave AS sifD ON sifD.Drzava=i.drzava
WHERE aktiven='1' AND status=2 ORDER BY naziv1";
$result=mysql_query($query);
$no=mysql_num_rows($result);
$izpis.="
TEMATSKI KOORDINATORJI ($no)
";
while($row=mysql_fetch_row($result)){
$test_chr=$row[1]{0};
$test_chr=strtoupper($test_chr);
$izpis.="
$row[1]
";
if ($row[2]) $izpis.= "$row[2]
";
if ($row[4]) $izpis.= "$row[3], $row[4] $row[6]";
else if ($row[5]) $izpis.= "$row[5], $row[7]";
$izpis.="
";
}
$izpis.="