"); printf("
"); printf("
$tit
"); printf(""); printf("",$t_id); $tx_nm = sprintf("$tx_nm"); $tx_nm = sprintf("$tx_nm"); } else { //$lnkfa = ""; //$tx_nm = sprintf("$tx_nm",$t_id); $tx_nm = sprintf("$tx_nm"); $tx_nm = sprintf("$tx_nm"); if($f+1==$rwsa) $tx_nm = "$tx_nm
"); printf("
"); //printf("%s",prt($txt)); $from = "FROM stuk WHERE tonen = 1"; $sql = "SELECT jaar $from group by jaar order by jaar desc"; $lst = mysql_query($sql); $rws = mysql_num_rows($lst); //printf("

$sql -> $rws

"); for ($j=0; $j<$rws; $j=$j+1) { $s_ja2 = mysql_result($lst,$j,"jaar"); $s_ja1 = $s_ja2-1; //printf("Seizoen $s_ja1 - $s_ja2"); printf("Seizoen $s_ja1 - $s_ja2"); $from = "FROM stuk WHERE tonen = 1"; $sqls = "SELECT id, naam, type, genre $from AND jaar = $s_ja2 ORDER BY nr"; $lsts = mysql_query($sqls); $rwss = mysql_num_rows($lsts); printf(""); for ($i=0; $i<$rwss; $i=$i+1) { $t_id = mysql_result($lsts,$i,"id"); $t_nm = mysql_result($lsts,$i,"naam"); $t_ty = mysql_result($lsts,$i,"type"); $t_ge = mysql_result($lsts,$i,"genre"); if($t_ty==4) $tx_ty = "Bonte"; else $tx_ty = dom_wa(75,$t_ty,0); $tx_ge = dom_wa(14,$t_ge,0); $url = "p_voorstelling.php?ses=$ses&tst=$tst&pag=8&key=$t_id"; $tx_nm = "$t_nm"; $foto = 0; if($tst>=0) { if(instr(".$t_id.",".46.50.53.54.57.59.66.70.82.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.104.106.")>0) { if($tst>=0) { $foto = 1; //$tx_nm = sprintf("$tx_nm - Foto's",$t_id * -1); $tx_nm = "
"; //$tx_nm = sprintf("$tx_nm",$t_id * -1); $tx_nm = sprintf("$tx_nm",$t_id * -1); //$tx_nm = sprintf("$tx_nm",$t_id * -1); $tx_nm = "$tx_nm
$tx_nm - - Foto's
"; } } else { $sqla = "SELECT * FROM album a WHERE type = 1 AND type_id = $t_id AND tonen = 1 AND ( SELECT COUNT(*) FROM docs WHERE tonen = 1 AND soort = 1 AND type = 1 AND type_id = a.id ) > 0 ORDER BY nr"; $lsta = mysql_query($sqla); $rwsa = mysql_num_rows($lsta); $foto = $rwsa; if($rws>0) { for ($f=0; $f<$rwsa; $f=$f+1) { $t_id = mysql_result($lsta,$f,"id"); $t_nr = mysql_result($lsta,$f,"nr"); $t_ti = mysql_result($lsta,$f,"titel"); $tx_nm = ""; $lnkfa = ""; $lnkft = sprintf("%s",$t_ti); if($rwsa==1) { //$lnkfa = ""; $tx_nm = sprintf("$tx_nm"); $tx_nm = "$tx_nm
$tx_nm - $lnkfa
"; } if($rwsa>1) { if($t_ti=="") $t_ti = "Album $t_nr"; if($f==0) { //$lnkfa = ""; //$tx_nm = sprintf("$tx_nm
$t_ti - $lnkfa$lnkft$t_ti | $lnkfa$lnkft
"; } } } } } } $fid = 1; $func = "Regie"; $sqlr = "SELECT b.voornaam vnm, b.naam anm FROM functie a, person b WHERE a.pers_id = b.id AND func_id = $fid AND stuk_id = $t_id ORDER BY 1, 2"; $lstr = mysql_query($sqlr); $rwsr = mysql_num_rows($lstr); $temp = ""; //if($rwsr>1) $func = sprintf("%ss",$func); if($rwsr>0) { for ($r=0; $r<$rwsr; $r=$r+1) { $t_vnm = mysql_result($lstr,$r,"vnm"); $t_anm = mysql_result($lstr,$r,"anm"); if($r==0) $temp = "$t_vnm $t_anm"; else $temp = "$temp, $t_vnm $t_anm"; } $tx_reg = "$func:$temp"; } else $tx_reg = "$spa"; $fid = 2; $func = "Auteur"; $sqlr = "SELECT b.voornaam vnm, b.naam anm FROM functie a, person b WHERE a.pers_id = b.id AND func_id = $fid AND stuk_id = $t_id ORDER BY 1, 2"; $lstr = mysql_query($sqlr); $rwsr = mysql_num_rows($lstr); $temp = ""; if($rwsr>1) $func = sprintf("%ss",$func); if($rwsr>0) { for ($r=0; $r<$rwsr; $r=$r+1) { $t_vnm = mysql_result($lstr,$r,"vnm"); $t_anm = mysql_result($lstr,$r,"anm"); if($r==0) $temp = "$t_vnm $t_anm"; else $temp = "$temp, $t_vnm $t_anm"; } $tx_aut = "$func:$temp"; } else $tx_aut = "$spa"; if($foto>0) { printf("
-
"); printf("
$tx_ty
:
"); } else { printf("-"); printf("$tx_ty:"); } printf("$tx_nm"); //printf("$t_ge"); printf(""); /* printf("$spa"); printf("Genre$br1:$tx_ge"); printf("$tx_reg $tx_aut"); //printf("Auteur:$t_ge"); printf(""); */ } printf(""); printf("

"); } printf(""); printf(""); printf(""); printf(""); printf(""); include 'i_foot.php'; ?>