= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%' or `TITLE` Like '%$R2%' or `TTLABEL` Like '%$R2%') and YEAR(`DBDATUM`) >= '$R4'order by S,COMPOSER,TITLE";
break;
case 'C':
$query = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%') and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%') and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE";
break;
case 'T':
$query = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE";
break;
case 'L':
$query = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER";
break;
}
}
else
switch ($R3) {
case 'A':
$query = "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 LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$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':
$query = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%') and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%') and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE";
break;
case 'T':
$query = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE";
break;
case 'L':
$query = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$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")
{
$query = "SELECT * FROM musikarchiv where `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE";
}
else
{
$query = "SELECT * FROM musikarchiv where `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$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':
$query = "SELECT * FROM musikarchiv where (`COMPOSER` Like '%$R2%' or `TITLE` Like '%$R2%') and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$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':
$query = "SELECT * FROM musikarchiv where `COMPOSER` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where `COMPOSER` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE";
break;
case 'T':
$query = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE";
break;
case 'L':
$query = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$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':
$query = "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 LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$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':
$query = "SELECT * FROM musikarchiv where `COMPOSER` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$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':
$query = "SELECT * FROM musikarchiv where `TITLE` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$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':
$query = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE LIMIT $AktuelleSeite, $ErgebnisseProSeite";
$querytotal = "SELECT * FROM musikarchiv where `TTLABEL` Like '%$R2%' and `S` = '$R1' and YEAR(`DBDATUM`) >= '$R4' and `TT` = '$R5' order by S,COMPOSER,TITLE";
break;
}
$result = mysql_query($query);
$resulttotal = mysql_query($querytotal);
$number = mysql_num_rows($result);
$anzahl = mysql_num_rows($resulttotal);
?>
0)
{
$SeiteAktuell = (($AktuelleSeite/$ErgebnisseProSeite)+1);
}
else
{
$SeiteAktuell = 1;
}
if($anzahl > $ErgebnisseProSeite)
{
$Seiten = intval($anzahl/$ErgebnisseProSeite);
echo "
" . $anzahl . " " . sf_itemsfound . sf_page ." :" ;
if($anzahl%$ErgebnisseProSeite)
{
$Seiten++;
}
}
else
echo "
" . $anzahl . " " . sf_itemsfound ."";
for($i = 1; $i <= $Seiten; $i++)
{
if ($i == $SeiteAktuell)
{
$iform = str_pad($i,2,'0',STR_PAD_LEFT);
echo "
$iform ";
}
else
{
$iform = str_pad($i,2,'0',STR_PAD_LEFT);
echo "
$iform ";
}
}
$Itemvon = ((($SeiteAktuell-1)*$ErgebnisseProSeite))+1;
if ($anzahl < $ErgebnisseProSeite)
{
$Itembis = $anzahl;
}
else
{
$Itembis =($Itemvon+$ErgebnisseProSeite-1);
if ($Itembis > $anzahl)
{
$Itembis = $anzahl;
}
}
if ($anzahl>0)
echo "
(" .sf_pageaktuell. ": $SeiteAktuell / " .sf_item . "$Itemvon - $Itembis)
";
?>
| S |
COMPOSER |
TITLE |
LABEL |
TT |
TIME |
|
|
|
|
|
|
