datum |
naam locatie/festival |
bands |
opm. |
print("$maand0 |
");
$rs = $conn->Execute("SELECT * FROM reservering WHERE verify = 'yes' AND datu>$d0 AND datu<$d1 ORDER BY datu");
// laat alle resultaten zien
while( !$rs->EOF ) {
$dat = $rs->Fields("dat");
$locatie = $rs->Fields("locatie");
$site = $rs->Fields("site");
$band1 = $rs->Fields("band1");
$site1 = $rs->Fields("site1");
$band2 = $rs->Fields("band2");
$site2 = $rs->Fields("site2");
$band3 = $rs->Fields("band3");
$site3 = $rs->Fields("site3");
$band4 = $rs->Fields("band4");
$site4 = $rs->Fields("site4");
$band5 = $rs->Fields("band5");
$site5 = $rs->Fields("site5");
$band6 = $rs->Fields("band6");
$site6 = $rs->Fields("site6");
$band7 = $rs->Fields("band7");
$site7 = $rs->Fields("site7");
$band8 = $rs->Fields("band8");
$site8 = $rs->Fields("site8");
$band9 = $rs->Fields("band9");
$site9 = $rs->Fields("site9");
$band10 = $rs->Fields("band10");
$site10 = $rs->Fields("site10");
$band11 = $rs->Fields("band11");
$site11 = $rs->Fields("site11");
$band12 = $rs->Fields("band12");
$site12 = $rs->Fields("site12");
$band13 = $rs->Fields("band13");
$site13 = $rs->Fields("site13");
$band14 = $rs->Fields("band14");
$site14 = $rs->Fields("site14");
$opmerking = $rs->Fields("opmerking");
if($site==".") {} else {$locatie= "$a".$site->value."$b".$locatie->value."$c";}
if($band1 == "."){$band1= "";} else {if($site1=="."){$band1="$band1$d";} else {$band1= "$a".$site1->value."$b".$band1->value."$c";}}
if($band2 == "."){$band2= "";} else {if($site2=="."){$band2="$band2$d";} else {$band2= "$a".$site2->value."$b".$band2->value."$c";}}
if($band3 == "."){$band3= "";} else {if($site3=="."){$band3="$band3$d";} else {$band3= "$a".$site3->value."$b".$band3->value."$c";}}
if($band4 == "."){$band4= "";} else {if($site4=="."){$band4="$band4$d";} else {$band4= "$a".$site4->value."$b".$band4->value."$c";}}
if($band5 == "."){$band5= "";} else {if($site5=="."){$band5="$band5$d";} else {$band5= "$a".$site5->value."$b".$band5->value."$c";}}
if($band6 == "."){$band6= "";} else {if($site6=="."){$band6="$band6$d";} else {$band6= "$a".$site6->value."$b".$band6->value."$c";}}
if($band7 == "."){$band7= "";} else {if($site7=="."){$band7="$band7$d";} else {$band7= "$a".$site7->value."$b".$band7->value."$c";}}
if($band8 == "."){$band8= "";} else {if($site8=="."){$band8="$band8$d";} else {$band8= "$a".$site8->value."$b".$band8->value."$c";}}
if($band9 == "."){$band9= "";} else {if($site9=="."){$band9="$band9$d";} else {$band9= "$a".$site9->value."$b".$band9->value."$c";}}
if($band10 == "."){$band10= "";} else {if($site10=="."){$band10="$band10$d";} else {$band10= "$a".$site10->value."$b".$band10->value."$c";}}
if($band11 == "."){$band11= "";} else {if($site11=="."){$band11="$band11$d";} else {$band11= "$a".$site11->value."$b".$band11->value."$c";}}
if($band12 == "."){$band12= "";} else {if($site12=="."){$band12="$band12$d";} else {$band12= "$a".$site12->value."$b".$band12->value."$c";}}
if($band13 == "."){$band13= "";} else {if($site13=="."){$band13="$band13$d";} else {$band13= "$a".$site13->value."$b".$band13->value."$c";}}
if($band14 == "."){$band14= "";} else {if($site14=="."){$band14="$band14$d";} else {$band14= "$a".$site14->value."$b".$band14->value."$c";}}
print(" ".$dat->value." |
$locatie |
$band1$band2$band3$band4$band5$band6$band7$band8$band9$band10$band11$band12$band13$band14
| ".$opmerking->value."
|
");
// echo "Veld1: ". $fv->value ."
\n";
$rs->MoveNext( );
}
print("$maand1 |
");
$rs = $conn->Execute("SELECT * FROM reservering WHERE verify = 'yes' AND datu>=$d1 AND datu<$d2 ORDER BY datu");
// laat alle resultaten zien
while( !$rs->EOF ) {
$dat = $rs->Fields("dat");
$locatie = $rs->Fields("locatie");
$site = $rs->Fields("site");
$band1 = $rs->Fields("band1");
$site1 = $rs->Fields("site1");
$band2 = $rs->Fields("band2");
$site2 = $rs->Fields("site2");
$band3 = $rs->Fields("band3");
$site3 = $rs->Fields("site3");
$band4 = $rs->Fields("band4");
$site4 = $rs->Fields("site4");
$band5 = $rs->Fields("band5");
$site5 = $rs->Fields("site5");
$band6 = $rs->Fields("band6");
$site6 = $rs->Fields("site6");
$band7 = $rs->Fields("band7");
$site7 = $rs->Fields("site7");
$band8 = $rs->Fields("band8");
$site8 = $rs->Fields("site8");
$band9 = $rs->Fields("band9");
$site9 = $rs->Fields("site9");
$band10 = $rs->Fields("band10");
$site10 = $rs->Fields("site10");
$band11 = $rs->Fields("band11");
$site11 = $rs->Fields("site11");
$band12 = $rs->Fields("band12");
$site12 = $rs->Fields("site12");
$band13 = $rs->Fields("band13");
$site13 = $rs->Fields("site13");
$band14 = $rs->Fields("band14");
$site14 = $rs->Fields("site14");
$opmerking = $rs->Fields("opmerking");
if($site==".") {} else {$locatie= "$a".$site->value."$b".$locatie->value."$c";}
if($band1 == "."){$band1= "";} else {if($site1=="."){$band1="$band1$d";} else {$band1= "$a".$site1->value."$b".$band1->value."$c";}}
if($band2 == "."){$band2= "";} else {if($site2=="."){$band2="$band2$d";} else {$band2= "$a".$site2->value."$b".$band2->value."$c";}}
if($band3 == "."){$band3= "";} else {if($site3=="."){$band3="$band3$d";} else {$band3= "$a".$site3->value."$b".$band3->value."$c";}}
if($band4 == "."){$band4= "";} else {if($site4=="."){$band4="$band4$d";} else {$band4= "$a".$site4->value."$b".$band4->value."$c";}}
if($band5 == "."){$band5= "";} else {if($site5=="."){$band5="$band5$d";} else {$band5= "$a".$site5->value."$b".$band5->value."$c";}}
if($band6 == "."){$band6= "";} else {if($site6=="."){$band6="$band6$d";} else {$band6= "$a".$site6->value."$b".$band6->value."$c";}}
if($band7 == "."){$band7= "";} else {if($site7=="."){$band7="$band7$d";} else {$band7= "$a".$site7->value."$b".$band7->value."$c";}}
if($band8 == "."){$band8= "";} else {if($site8=="."){$band8="$band8$d";} else {$band8= "$a".$site8->value."$b".$band8->value."$c";}}
if($band9 == "."){$band9= "";} else {if($site9=="."){$band9="$band9$d";} else {$band9= "$a".$site9->value."$b".$band9->value."$c";}}
if($band10 == "."){$band10= "";} else {if($site10=="."){$band10="$band10$d";} else {$band10= "$a".$site10->value."$b".$band10->value."$c";}}
if($band11 == "."){$band11= "";} else {if($site11=="."){$band11="$band11$d";} else {$band11= "$a".$site11->value."$b".$band11->value."$c";}}
if($band12 == "."){$band12= "";} else {if($site12=="."){$band12="$band12$d";} else {$band12= "$a".$site12->value."$b".$band12->value."$c";}}
if($band13 == "."){$band13= "";} else {if($site13=="."){$band13="$band13$d";} else {$band13= "$a".$site13->value."$b".$band13->value."$c";}}
if($band14 == "."){$band14= "";} else {if($site14=="."){$band14="$band14$d";} else {$band14= "$a".$site14->value."$b".$band14->value."$c";}}
print(" ".$dat->value." |
$locatie |
$band1$band2$band3$band4$band5$band6$band7$band8$band9$band10$band11$band12$band13$band14
| ".$opmerking->value."
|
");
// echo "Veld1: ". $fv->value ."
\n";
$rs->MoveNext( );
}
print("$maand2 |
");
$rs = $conn->Execute("SELECT * FROM reservering WHERE verify = 'yes' AND datu>=$d2 AND datu<$d3 ORDER BY datu");
// laat alle resultaten zien
while( !$rs->EOF ) {
$dat = $rs->Fields("dat");
$locatie = $rs->Fields("locatie");
$site = $rs->Fields("site");
$band1 = $rs->Fields("band1");
$site1 = $rs->Fields("site1");
$band2 = $rs->Fields("band2");
$site2 = $rs->Fields("site2");
$band3 = $rs->Fields("band3");
$site3 = $rs->Fields("site3");
$band4 = $rs->Fields("band4");
$site4 = $rs->Fields("site4");
$band5 = $rs->Fields("band5");
$site5 = $rs->Fields("site5");
$band6 = $rs->Fields("band6");
$site6 = $rs->Fields("site6");
$band7 = $rs->Fields("band7");
$site7 = $rs->Fields("site7");
$band8 = $rs->Fields("band8");
$site8 = $rs->Fields("site8");
$band9 = $rs->Fields("band9");
$site9 = $rs->Fields("site9");
$band10 = $rs->Fields("band10");
$site10 = $rs->Fields("site10");
$band11 = $rs->Fields("band11");
$site11 = $rs->Fields("site11");
$band12 = $rs->Fields("band12");
$site12 = $rs->Fields("site12");
$band13 = $rs->Fields("band13");
$site13 = $rs->Fields("site13");
$band14 = $rs->Fields("band14");
$site14 = $rs->Fields("site14");
$opmerking = $rs->Fields("opmerking");
if($site==".") {} else {$locatie= "$a".$site->value."$b".$locatie->value."$c";}
if($band1 == "."){$band1= "";} else {if($site1=="."){$band1="$band1$d";} else {$band1= "$a".$site1->value."$b".$band1->value."$c";}}
if($band2 == "."){$band2= "";} else {if($site2=="."){$band2="$band2$d";} else {$band2= "$a".$site2->value."$b".$band2->value."$c";}}
if($band3 == "."){$band3= "";} else {if($site3=="."){$band3="$band3$d";} else {$band3= "$a".$site3->value."$b".$band3->value."$c";}}
if($band4 == "."){$band4= "";} else {if($site4=="."){$band4="$band4$d";} else {$band4= "$a".$site4->value."$b".$band4->value."$c";}}
if($band5 == "."){$band5= "";} else {if($site5=="."){$band5="$band5$d";} else {$band5= "$a".$site5->value."$b".$band5->value."$c";}}
if($band6 == "."){$band6= "";} else {if($site6=="."){$band6="$band6$d";} else {$band6= "$a".$site6->value."$b".$band6->value."$c";}}
if($band7 == "."){$band7= "";} else {if($site7=="."){$band7="$band7$d";} else {$band7= "$a".$site7->value."$b".$band7->value."$c";}}
if($band8 == "."){$band8= "";} else {if($site8=="."){$band8="$band8$d";} else {$band8= "$a".$site8->value."$b".$band8->value."$c";}}
if($band9 == "."){$band9= "";} else {if($site9=="."){$band9="$band9$d";} else {$band9= "$a".$site9->value."$b".$band9->value."$c";}}
if($band10 == "."){$band10= "";} else {if($site10=="."){$band10="$band10$d";} else {$band10= "$a".$site10->value."$b".$band10->value."$c";}}
if($band11 == "."){$band11= "";} else {if($site11=="."){$band11="$band11$d";} else {$band11= "$a".$site11->value."$b".$band11->value."$c";}}
if($band12 == "."){$band12= "";} else {if($site12=="."){$band12="$band12$d";} else {$band12= "$a".$site12->value."$b".$band12->value."$c";}}
if($band13 == "."){$band13= "";} else {if($site13=="."){$band13="$band13$d";} else {$band13= "$a".$site13->value."$b".$band13->value."$c";}}
if($band14 == "."){$band14= "";} else {if($site14=="."){$band14="$band14$d";} else {$band14= "$a".$site14->value."$b".$band14->value."$c";}}
print(" ".$dat->value." |
$locatie |
$band1$band2$band3$band4$band5$band6$band7$band8$band9$band10$band11$band12$band13$band14
| ".$opmerking->value."
|
");
// echo "Veld1: ". $fv->value ."
\n";
$rs->MoveNext( );
}
print("$maand3 |
");
$rs = $conn->Execute("SELECT * FROM reservering WHERE verify = 'yes' AND datu>=$d3 AND datu<$d4 ORDER BY datu");
// laat alle resultaten zien
while( !$rs->EOF ) {
$dat = $rs->Fields("dat");
$locatie = $rs->Fields("locatie");
$site = $rs->Fields("site");
$band1 = $rs->Fields("band1");
$site1 = $rs->Fields("site1");
$band2 = $rs->Fields("band2");
$site2 = $rs->Fields("site2");
$band3 = $rs->Fields("band3");
$site3 = $rs->Fields("site3");
$band4 = $rs->Fields("band4");
$site4 = $rs->Fields("site4");
$band5 = $rs->Fields("band5");
$site5 = $rs->Fields("site5");
$band6 = $rs->Fields("band6");
$site6 = $rs->Fields("site6");
$band7 = $rs->Fields("band7");
$site7 = $rs->Fields("site7");
$band8 = $rs->Fields("band8");
$site8 = $rs->Fields("site8");
$band9 = $rs->Fields("band9");
$site9 = $rs->Fields("site9");
$band10 = $rs->Fields("band10");
$site10 = $rs->Fields("site10");
$band11 = $rs->Fields("band11");
$site11 = $rs->Fields("site11");
$band12 = $rs->Fields("band12");
$site12 = $rs->Fields("site12");
$band13 = $rs->Fields("band13");
$site13 = $rs->Fields("site13");
$band14 = $rs->Fields("band14");
$site14 = $rs->Fields("site14");
$opmerking = $rs->Fields("opmerking");
if($site==".") {} else {$locatie= "$a".$site->value."$b".$locatie->value."$c";}
if($band1 == "."){$band1= "";} else {if($site1=="."){$band1="$band1$d";} else {$band1= "$a".$site1->value."$b".$band1->value."$c";}}
if($band2 == "."){$band2= "";} else {if($site2=="."){$band2="$band2$d";} else {$band2= "$a".$site2->value."$b".$band2->value."$c";}}
if($band3 == "."){$band3= "";} else {if($site3=="."){$band3="$band3$d";} else {$band3= "$a".$site3->value."$b".$band3->value."$c";}}
if($band4 == "."){$band4= "";} else {if($site4=="."){$band4="$band4$d";} else {$band4= "$a".$site4->value."$b".$band4->value."$c";}}
if($band5 == "."){$band5= "";} else {if($site5=="."){$band5="$band5$d";} else {$band5= "$a".$site5->value."$b".$band5->value."$c";}}
if($band6 == "."){$band6= "";} else {if($site6=="."){$band6="$band6$d";} else {$band6= "$a".$site6->value."$b".$band6->value."$c";}}
if($band7 == "."){$band7= "";} else {if($site7=="."){$band7="$band7$d";} else {$band7= "$a".$site7->value."$b".$band7->value."$c";}}
if($band8 == "."){$band8= "";} else {if($site8=="."){$band8="$band8$d";} else {$band8= "$a".$site8->value."$b".$band8->value."$c";}}
if($band9 == "."){$band9= "";} else {if($site9=="."){$band9="$band9$d";} else {$band9= "$a".$site9->value."$b".$band9->value."$c";}}
if($band10 == "."){$band10= "";} else {if($site10=="."){$band10="$band10$d";} else {$band10= "$a".$site10->value."$b".$band10->value."$c";}}
if($band11 == "."){$band11= "";} else {if($site11=="."){$band11="$band11$d";} else {$band11= "$a".$site11->value."$b".$band11->value."$c";}}
if($band12 == "."){$band12= "";} else {if($site12=="."){$band12="$band12$d";} else {$band12= "$a".$site12->value."$b".$band12->value."$c";}}
if($band13 == "."){$band13= "";} else {if($site13=="."){$band13="$band13$d";} else {$band13= "$a".$site13->value."$b".$band13->value."$c";}}
if($band14 == "."){$band14= "";} else {if($site14=="."){$band14="$band14$d";} else {$band14= "$a".$site14->value."$b".$band14->value."$c";}}
print(" ".$dat->value." |
$locatie |
$band1$band2$band3$band4$band5$band6$band7$band8$band9$band10$band11$band12$band13$band14
| ".$opmerking->value."
|
");
// echo "Veld1: ". $fv->value ."
\n";
$rs->MoveNext( );
}
print("$maand4 |
");
$rs = $conn->Execute("SELECT * FROM reservering WHERE verify = 'yes' AND datu>=$d4 AND datu<$d5 ORDER BY datu");
// laat alle resultaten zien
while( !$rs->EOF ) {
$dat = $rs->Fields("dat");
$locatie = $rs->Fields("locatie");
$site = $rs->Fields("site");
$band1 = $rs->Fields("band1");
$site1 = $rs->Fields("site1");
$band2 = $rs->Fields("band2");
$site2 = $rs->Fields("site2");
$band3 = $rs->Fields("band3");
$site3 = $rs->Fields("site3");
$band4 = $rs->Fields("band4");
$site4 = $rs->Fields("site4");
$band5 = $rs->Fields("band5");
$site5 = $rs->Fields("site5");
$band6 = $rs->Fields("band6");
$site6 = $rs->Fields("site6");
$band7 = $rs->Fields("band7");
$site7 = $rs->Fields("site7");
$band8 = $rs->Fields("band8");
$site8 = $rs->Fields("site8");
$band9 = $rs->Fields("band9");
$site9 = $rs->Fields("site9");
$band10 = $rs->Fields("band10");
$site10 = $rs->Fields("site10");
$band11 = $rs->Fields("band11");
$site11 = $rs->Fields("site11");
$band12 = $rs->Fields("band12");
$site12 = $rs->Fields("site12");
$band13 = $rs->Fields("band13");
$site13 = $rs->Fields("site13");
$band14 = $rs->Fields("band14");
$site14 = $rs->Fields("site14");
$opmerking = $rs->Fields("opmerking");
if($site==".") {} else {$locatie= "$a".$site->value."$b".$locatie->value."$c";}
if($band1 == "."){$band1= "";} else {if($site1=="."){$band1="$band1$d";} else {$band1= "$a".$site1->value."$b".$band1->value."$c";}}
if($band2 == "."){$band2= "";} else {if($site2=="."){$band2="$band2$d";} else {$band2= "$a".$site2->value."$b".$band2->value."$c";}}
if($band3 == "."){$band3= "";} else {if($site3=="."){$band3="$band3$d";} else {$band3= "$a".$site3->value."$b".$band3->value."$c";}}
if($band4 == "."){$band4= "";} else {if($site4=="."){$band4="$band4$d";} else {$band4= "$a".$site4->value."$b".$band4->value."$c";}}
if($band5 == "."){$band5= "";} else {if($site5=="."){$band5="$band5$d";} else {$band5= "$a".$site5->value."$b".$band5->value."$c";}}
if($band6 == "."){$band6= "";} else {if($site6=="."){$band6="$band6$d";} else {$band6= "$a".$site6->value."$b".$band6->value."$c";}}
if($band7 == "."){$band7= "";} else {if($site7=="."){$band7="$band7$d";} else {$band7= "$a".$site7->value."$b".$band7->value."$c";}}
if($band8 == "."){$band8= "";} else {if($site8=="."){$band8="$band8$d";} else {$band8= "$a".$site8->value."$b".$band8->value."$c";}}
if($band9 == "."){$band9= "";} else {if($site9=="."){$band9="$band9$d";} else {$band9= "$a".$site9->value."$b".$band9->value."$c";}}
if($band10 == "."){$band10= "";} else {if($site10=="."){$band10="$band10$d";} else {$band10= "$a".$site10->value."$b".$band10->value."$c";}}
if($band11 == "."){$band11= "";} else {if($site11=="."){$band11="$band11$d";} else {$band11= "$a".$site11->value."$b".$band11->value."$c";}}
if($band12 == "."){$band12= "";} else {if($site12=="."){$band12="$band12$d";} else {$band12= "$a".$site12->value."$b".$band12->value."$c";}}
if($band13 == "."){$band13= "";} else {if($site13=="."){$band13="$band13$d";} else {$band13= "$a".$site13->value."$b".$band13->value."$c";}}
if($band14 == "."){$band14= "";} else {if($site14=="."){$band14="$band14$d";} else {$band14= "$a".$site14->value."$b".$band14->value."$c";}}
print(" ".$dat->value." |
$locatie |
$band1$band2$band3$band4$band5$band6$band7$band8$band9$band10$band11$band12$band13$band14
| ".$opmerking->value."
|
");
// echo "Veld1: ". $fv->value ."
\n";
$rs->MoveNext( );
}
print("$maand5 |
");
$rs = $conn->Execute("SELECT * FROM reservering WHERE verify = 'yes' AND datu>=$d5 AND datu<$d6 ORDER BY datu");
// laat alle resultaten zien
while( !$rs->EOF ) {
$dat = $rs->Fields("dat");
$locatie = $rs->Fields("locatie");
$site = $rs->Fields("site");
$band1 = $rs->Fields("band1");
$site1 = $rs->Fields("site1");
$band2 = $rs->Fields("band2");
$site2 = $rs->Fields("site2");
$band3 = $rs->Fields("band3");
$site3 = $rs->Fields("site3");
$band4 = $rs->Fields("band4");
$site4 = $rs->Fields("site4");
$band5 = $rs->Fields("band5");
$site5 = $rs->Fields("site5");
$band6 = $rs->Fields("band6");
$site6 = $rs->Fields("site6");
$band7 = $rs->Fields("band7");
$site7 = $rs->Fields("site7");
$band8 = $rs->Fields("band8");
$site8 = $rs->Fields("site8");
$band9 = $rs->Fields("band9");
$site9 = $rs->Fields("site9");
$band10 = $rs->Fields("band10");
$site10 = $rs->Fields("site10");
$band11 = $rs->Fields("band11");
$site11 = $rs->Fields("site11");
$band12 = $rs->Fields("band12");
$site12 = $rs->Fields("site12");
$band13 = $rs->Fields("band13");
$site13 = $rs->Fields("site13");
$band14 = $rs->Fields("band14");
$site14 = $rs->Fields("site14");
$opmerking = $rs->Fields("opmerking");
if($band1 == "."){$band1= "";}
if($band2 == "."){$band2= "";}
if($band3 == "."){$band3= "";}
if($band4 == "."){$band4= "";}
if($band5 == "."){$band5= "";}
if($band6 == "."){$band6= "";}
if($band7 == "."){$band7= "";}
if($band8 == "."){$band8= "";}
if($band9 == "."){$band9= "";}
if($band10 == "."){$band10= "";}
if($band11 == "."){$band11= "";}
if($band12 == "."){$band12= "";}
if($band13 == "."){$band13= "";}
if($band14== "."){$band14= "";}
print("".$dat->value." |
$a".$site->value." $b".$locatie->value."$c |
$a".$site1->value." $b".$band1->value." $c
$a".$site2->value." $b".$band2->value."$c
$a".$site3->value." $b".$band3->value."$c
$a".$site4->value." $b".$band4->value."$c
$a".$site5->value." $b".$band5->value."$c
$a".$site6->value." $b".$band6->value."$c
$a".$site7->value." $b".$band7->value."$c
$a".$site8->value." $b".$band8->value."$c
$a".$site9->value." $b".$band9->value."$c
$a".$site10->value." $b".$band10->value."$c
$a".$site11->value." $b".$band11->value."$c
$a".$site12->value." $b".$band12->value."$c
$a".$site13->value." $b".$band13->value."$c
$a".$site14->value." $b".$band14->value."$c
| ".$opmerking->value."
|
");
// echo "Veld1: ". $fv->value ."
\n";
$rs->MoveNext( );
}
print("$maand6 |
");
$rs = $conn->Execute("SELECT * FROM reservering WHERE verify = 'yes' AND datu>=$d6 AND datu<$d7 ORDER BY datu");
// laat alle resultaten zien
while( !$rs->EOF ) {
$dat = $rs->Fields("dat");
$locatie = $rs->Fields("locatie");
$site = $rs->Fields("site");
$band1 = $rs->Fields("band1");
$site1 = $rs->Fields("site1");
$band2 = $rs->Fields("band2");
$site2 = $rs->Fields("site2");
$band3 = $rs->Fields("band3");
$site3 = $rs->Fields("site3");
$band4 = $rs->Fields("band4");
$site4 = $rs->Fields("site4");
$band5 = $rs->Fields("band5");
$site5 = $rs->Fields("site5");
$band6 = $rs->Fields("band6");
$site6 = $rs->Fields("site6");
$band7 = $rs->Fields("band7");
$site7 = $rs->Fields("site7");
$band8 = $rs->Fields("band8");
$site8 = $rs->Fields("site8");
$band9 = $rs->Fields("band9");
$site9 = $rs->Fields("site9");
$band10 = $rs->Fields("band10");
$site10 = $rs->Fields("site10");
$band11 = $rs->Fields("band11");
$site11 = $rs->Fields("site11");
$band12 = $rs->Fields("band12");
$site12 = $rs->Fields("site12");
$band13 = $rs->Fields("band13");
$site13 = $rs->Fields("site13");
$band14 = $rs->Fields("band14");
$site14 = $rs->Fields("site14");
$opmerking = $rs->Fields("opmerking");
if($site==".") {} else {$locatie= "$a".$site->value."$b".$locatie->value."$c";}
if($band1 == "."){$band1= "";} else {if($site1=="."){$band1="$band1$d";} else {$band1= "$a".$site1->value."$b".$band1->value."$c";}}
if($band2 == "."){$band2= "";} else {if($site2=="."){$band2="$band2$d";} else {$band2= "$a".$site2->value."$b".$band2->value."$c";}}
if($band3 == "."){$band3= "";} else {if($site3=="."){$band3="$band3$d";} else {$band3= "$a".$site3->value."$b".$band3->value."$c";}}
if($band4 == "."){$band4= "";} else {if($site4=="."){$band4="$band4$d";} else {$band4= "$a".$site4->value."$b".$band4->value."$c";}}
if($band5 == "."){$band5= "";} else {if($site5=="."){$band5="$band5$d";} else {$band5= "$a".$site5->value."$b".$band5->value."$c";}}
if($band6 == "."){$band6= "";} else {if($site6=="."){$band6="$band6$d";} else {$band6= "$a".$site6->value."$b".$band6->value."$c";}}
if($band7 == "."){$band7= "";} else {if($site7=="."){$band7="$band7$d";} else {$band7= "$a".$site7->value."$b".$band7->value."$c";}}
if($band8 == "."){$band8= "";} else {if($site8=="."){$band8="$band8$d";} else {$band8= "$a".$site8->value."$b".$band8->value."$c";}}
if($band9 == "."){$band9= "";} else {if($site9=="."){$band9="$band9$d";} else {$band9= "$a".$site9->value."$b".$band9->value."$c";}}
if($band10 == "."){$band10= "";} else {if($site10=="."){$band10="$band10$d";} else {$band10= "$a".$site10->value."$b".$band10->value."$c";}}
if($band11 == "."){$band11= "";} else {if($site11=="."){$band11="$band11$d";} else {$band11= "$a".$site11->value."$b".$band11->value."$c";}}
if($band12 == "."){$band12= "";} else {if($site12=="."){$band12="$band12$d";} else {$band12= "$a".$site12->value."$b".$band12->value."$c";}}
if($band13 == "."){$band13= "";} else {if($site13=="."){$band13="$band13$d";} else {$band13= "$a".$site13->value."$b".$band13->value."$c";}}
if($band14 == "."){$band14= "";} else {if($site14=="."){$band14="$band14$d";} else {$band14= "$a".$site14->value."$b".$band14->value."$c";}}
print(" ".$dat->value." |
$locatie |
$band1$band2$band3$band4$band5$band6$band7$band8$band9$band10$band11$band12$band13$band14
| ".$opmerking->value."
|
");
// echo "Veld1: ". $fv->value ."
\n";
$rs->MoveNext( );
}
?>