$sql -> $rws

"); if($rws==0) printf("

Voorstelling niet gevonden

"); else { $t_nm = mysql_result($lst,$j,"naam"); $t_ja = mysql_result($lst,$j,"jaar"); $t_ty = mysql_result($lst,$j,"type"); $t_ge = mysql_result($lst,$j,"genre"); $t_tx = mysql_result($lst,$j,"tekst"); // ----------- Afbeelding $sqld = "SELECT * FROM docs WHERE soort = 4 AND type = 2 AND type_id = $key AND tonen = 1 ORDER BY id DESC"; $lstd = mysql_query($sqld); $rwsd = mysql_num_rows($lstd); } $album1 = 0; if($key==46 || $key==50 || $key==53 || $key==54 || $key==57 || $key==59 || $key==66 || $key==70 || $key==82 || $key==86 || $key==87 || $key==88 || $key==89 || $key==90 || $key==91 || $key==92 || $key==93 || $key==94 || $key==95 || $key==96 || $key==97 || $key==98 || $key==99 || $key==100 || $key==101 || $key==102 || $key==103 || $key==104 || $key==106 || $key==0) { $album1 = 1; printf("
$t_nm
"); if($tst>=0) { $alb = $key * -1; printf(""); printf(""); printf(""); printf("
Bekijk de foto's
"); } else { printf("

Bekijk de foto's

"); printf(""); } if($tst>=0) printf(" "); // SKIP else { printf(""); printf(""); // album1_$key printf("
"); // album1 if(len($t_tx)>0 || $rwsd>0) { printf(""); printf(""); printf("
"); //printf("
$t_nm
"); printf(""); printf(""); printf("
"); if($rwsd>0) { $url = sprintf("docs/img/%s",mysql_result($lstd,0,"naam")); printf("
"); } if(len($t_tx)>0) { printf("%s",fmt_txt($t_tx)); } printf("
"); printf("
"); } /* if($album1>0) { if($tst>0) { $key = $key * -1; printf("

Bekijk de fotos

"); } else { printf("

Bekijk de fotos

"); printf(""); } } */ printf("
"); // stuk_$key } else { printf(""); printf(""); printf("
"); printf("
$t_nm
"); if($tst>=0) { $sql = "SELECT * FROM album a WHERE type = 1 AND type_id = $key 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"; $lst = mysql_query($sql); $rws = mysql_num_rows($lst); if($rws>0) { //printf("SQL: $sql --> RWS: $rws"); for ($j=0; $j<$rws; $j=$j+1) { $t_id = mysql_result($lst,$j,"id"); $t_nr = mysql_result($lst,$j,"nr"); $t_ti = mysql_result($lst,$j,"titel"); //Bekijk de fotos if($rws==1) printf("Toon fotos"); elseif($j==0) printf("Foto's: "); if($rws>1) { if($t_ti=="") $t_ti = "Album $t_nr"; if($j==0) printf("$t_ti"); else printf(" | $t_ti"); } } } } printf(""); printf(""); printf("
"); printf("
"); //printf("%s",prt($txt)); if($rwsd>0) { $url = sprintf("docs/img/%s",mysql_result($lstd,0,"naam")); printf("
"); } if(len($t_tx)>0) { printf("%s",fmt_txt($t_tx)); } printf("
"); printf("
"); printf("
"); } include 'i_foot.php'; ?>