= '$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
|
sf_no |
|
|
|
|
| | No Tracklisting found | ";
else
while ($line = mysql_fetch_array($result)) { ?>
|
|
|
|
|
|
