= '$R4'order by S,COMPOSER,TITLE"; break; case 'C': $querytotal = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%') and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE"; break; case 'T': $querytotal = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE"; break; case 'L': $querytotal = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER"; break; } } else switch ($R3) { case 'A': $querytotal = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%' or `TITLE` Like '%$R2%' or `TTLABEL` Like '%$R2%') and YEAR(`DBDATUM`) >= '$R4'and `TT` = '$R5' order by S,COMPOSER,TITLE"; break; case 'C': $querytotal = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%') and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE"; break; case 'T': $querytotal = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE"; break; case 'L': $querytotal = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER"; break; } else if ($R2==""){ if ($R5=="All") { $querytotal = "SELECT * FROM musikarchiv where `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE"; } else { $querytotal = "SELECT * FROM musikarchiv where `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE"; } } else if ($R5 =="All"){ switch ($R3) { case 'A': $querytotal = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%' or `TITLE` Like '%$R2%') and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE"; break; case 'C': $querytotal = "SELECT * FROM musikarchiv where `COMPOSER` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE"; break; case 'T': $querytotal = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE"; break; case 'L': $querytotal = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE"; break; } } else switch ($R3) { case 'A': $querytotal = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%' or `TITLE` Like '%$R2%') and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE"; break; case 'C': $querytotal = "SELECT * FROM musikarchiv where `COMPOSER` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE"; break; case 'T': $querytotal = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE"; break; case 'L': $querytotal = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE"; break; } ?>
Track - Details
Cover

:

:

:

:   ()

:

:

"; else while ($line = mysql_fetch_array($result)) { ?>
sf_no
  No Tracklisting found