"; 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.="

"; } // if !$id else { $query="SELECT i.naziv1,i.naziv2,i.naslov,i.posta,sifP.Kraj,sifD.NazivDrzave,i.url,i.kontakt_ime,i.telefon,i.kontakt_eposta,i.posta1 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 id='$id'"; //$query="SELECT naziv1,naziv2,naslov,posta,kraj,drzava,spletna,kontaktna,telefon,mail FROM izvajalci AS i $result_tblRegister=mysql_fetch_row(mysql_query($query)); $n=0; $izpis.= "$result_tblRegister[0]
"; if ($result_tblRegister[1]) $izpis.= "$result_tblRegister[1]
"; //if ($result_tblRegister[2]) $izpis .= "  $result_tblRegister[2]
"; //$izpis .= "
"; if ($result_tblRegister[2]) $izpis.= "$result_tblRegister[2], $result_tblRegister[3] $result_tblRegister[4]"; else if ($result_tblRegister[10]) $izpis.= "$result_tblRegister[10], $result_tblRegister[5]"; $izpis.= "
"; //if ($result_tblRegister[3] || $result_tblRegister[2]) $izpis .= "$result_tblRegister[2], $result_tblRegister[3] $result_tblRegister[4]
"; if ($result_tblRegister[6] && $result_tblRegister[6]!="http://") { $result_tblRegister[6]=str_replace("http://","",$result_tblRegister[6]); $izpis .= "Spletna stran: http://$result_tblRegister[6]
"; } $izpis .= "
"; if ($result_tblRegister[7]) $izpis .= "Kontaktna oseba: $result_tblRegister[7]
"; if ($result_tblRegister[8]) $izpis .= "Telefon: $result_tblRegister[8]
"; if ($result_tblRegister[9]) { $e_posteA=explode(";",$result_tblRegister[9]); $n=0; foreach ($e_posteA as $eposte) { if (!$n) { $izpis.= "E-pošta: "; $n++; } if ($eposte) $izpis.= "$eposte "; } } $izpis.= "

Vse prireditve izbranega koordinatorja in koordiniranih organizacij
"; $izpis.="
Koordinirani izvajalci

"; $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 i.aktiven='1' AND (i.rkoord_id='$id' OR i.tkoord_id='$id') ORDER BY i.naziv1"; $result=mysql_query($query); $n=0; while($row=mysql_fetch_row($result)){ $n++; $test_chr=$row[1]{0}; $test_chr=strtoupper($test_chr); $izpis.=" $row[1]
"; if ($row[2]) $izpis.= "$row[2]
"; $izpis.="  "; if ($row[4]) $izpis.= "$row[3], $row[4] $row[6]"; else if ($row[5]) $izpis.= "$row[5], $row[7]"; $izpis.="

"; } $izpis.= "Skupaj koordiniranih izvajalcev: $n

"; } $naslov="Koordinatorji TVU $leto_db"; require "../../inc/jedro_koledar.php"; ?>