= '$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