Nowości i Zapowiedzi

"); if($wyd!=""){ echo(""); } echo("Wyświetl nowości i zapowiedzi z kategorii:  
  
"); echo("
"); if($wyd!=""){ echo(""); } echo("Sortuj według:     
"); if($wyd!=""){ if($kat=="0"){ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next')))"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next'))"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next')"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$prok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$next'"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$nrok' AND miesiac='$next'"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$next'"; } } } }else{ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next')))"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next'))"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next')"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$prok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$next'"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$nrok' AND miesiac='$next'"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$next'"; } } } } }elseif($kat=="0"){ if($l=="0"){ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next')))"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next'))"; //$zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$nrok' AND $miesiac='$next'))"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next')"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$prok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$next'"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$nrok' AND miesiac='$next'"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$next'"; } } } }else{ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next')))"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next'))"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next')"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$prok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$next'"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$nrok' AND miesiac='$next'"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$next'"; } } } } }else{ if($l=="0"){ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next')))"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next'))"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next')"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$prok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$next'"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$nrok' AND miesiac='$next'"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$next'"; } } } }else{ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next')))"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next'))"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next')"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$prok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$next'"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$nrok' AND miesiac='$next'"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev'"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$month'"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$next'"; } } } } } $wyk = mysql_query($zap); $i = mysql_num_rows($wyk); $j=$i; if($s==""){ $s="tytul"; } if($wyd==""){ echo("


0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
A | B | C | Ć | D | E | F | G | H | I | J | K | L | Ł | M | N | O | Ó | P | Q | R | S | Ś | T | U | V | W | X | Y | Z | Ż | Wszystkie

"); } echo("


Wyświetl nowości i zapowiedzi na miesiąc:
"); if($mies=="prev"){ echo(""); } echo("$miesiac[$prev]"); if($month=="1"){ echo(" $prok"); } echo("   |   "); if($mies=="now"){ echo(""); } echo("$miesiac[$month]   |   "); if($mies=="next"){ echo(""); } echo("$miesiac[$next]"); if($month=="12"){ echo(" $nrok"); } echo("   |   "); if($mies=="0"){ echo(""); } echo("Wszystkie z tych 3 miesięcy


"); if($wyd!=""){ $z = "SELECT * FROM $table_wyd WHERE id='$wyd'"; $w = mysql_query($z); while($rzad = mysql_fetch_array($w)){ $wyd_nazwa=$rzad['nazwa']; } echo("Nowości i zapowiedzi wydawnictwa $wyd_nazwa [razem: $i]:"); }elseif($kat!="0"){ if($l=="0"){ echo("Nowości i zapowiedzi z kategorii $kat1 [razem: $i]:"); }else{ $litera=ucfirst($l); echo("Nowości i zapowiedzi z kategorii $kat1 na literę $litera [razem: $i]:"); } }else{ if($l!="0"){ $litera=ucfirst($l); echo("Nowości i zapowiedzi na literę $litera [razem: $i]:"); }else{ echo("Wszystkie nowości i zapowiedzi [razem: $i]:"); } } echo("

"); if($j>$nownastr){ echo("

"); $max=ceil($j/$nownastr); if(!($str==1)){ $a=5; $st=$str-$a; while($st<=0){ $a--; $st=$str-$a; } $stp=$str-1; if($wyd!=""){ echo("<<<   "); if($str>6){ if($wyd!=""){ echo("1... "); }else{ echo("1... "); } } do{ if($wyd!=""){ echo("$st  "); }else{ echo("$st  "); } $a--; $st=$str-$a; }while($a>0&&$st>0); } echo("$str  "); if(!($str==$max)){ $b=1; $st=$str+$b; do{ if($wyd!=""){ echo("$st  "); }else{ echo("$st  "); } $b++; $st=$str+$b; }while($b<6&&$st<=$max); } if($wyd!=""){ echo("z  $max"); }else{ echo("z  $max"); } if(!($str==$max)){ $stn=$str+1; if($wyd!=""){ echo("   >>\">>>>"); } echo("
 

"); } if($wyd!=""){ if($kat=="0"){ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next'))) ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next')) ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next') ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$prok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$nrok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } } } }else{ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next'))) ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next')) ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next') ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$prok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$nrok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE wydawnictwo='$wyd' AND status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } } } } }elseif($kat=="0"){ if($l=="0"){ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next'))) ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next')) ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next') ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$prok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$nrok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } } } }else{ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next'))) ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next')) ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next') ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$prok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$nrok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } } } } }else{ if($l=="0"){ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next'))) ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next')) ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next') ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$prok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$nrok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND kat='$kat1' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } } } }else{ if($mies=="0"){ if($month=="1"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND ((rok='$prok' AND miesiac='$prev') OR (rok='$rok' AND (miesiac='$month' OR miesiac='$next'))) ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($month=="12"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND ((rok='$rok' AND (miesiac='$prev' OR miesiac='$month')) OR (rok='$nrok' AND miesiac='$next')) ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND (miesiac='$prev' OR miesiac='$month' OR miesiac='$next') ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($month=="1"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$prok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }elseif($month=="12"){ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$nrok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } }else{ if($mies=="prev"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$prev' ORDER BY $s LIMIT $pocz, $nownastr;"; }elseif($mies=="now"){ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$month' ORDER BY $s LIMIT $pocz, $nownastr;"; }else{ $zap = "SELECT * FROM $table_ks WHERE status>'0' AND tytul LIKE '$l%' AND kat='$kat1' AND rok='$rok' AND miesiac='$next' ORDER BY $s LIMIT $pocz, $nownastr;"; } } } } } $wyk = mysql_query($zap); $i = mysql_num_rows($wyk); if($i=="0"){ echo("

 

Brak nowości i zapowiedzi w tej kategorii


Dodaj nową książkę

"); }else{ while($rzad = mysql_fetch_array($wyk)){ $text=$rzad['opis']; $tresc=explode(".", $text); $okladka=$rzad['okladka']; $tytul=$rzad['tytul']; $kateg=$rzad['kat']; $rokks=$rzad['rok']; $miesks=$rzad['miesiac']; $ida=$rzad['ida']; $idk=$rzad['id']; $at=explode(",", $ida); $a="0"; while($at[$a]!=""){ $z = "SELECT * FROM $table_a WHERE id='$at[$a]'"; $w = mysql_query($z); while($rzad = mysql_fetch_array($w)){ $autor[$a]=$rzad['imie']." ".$rzad['nazwisko']; } $a++; } echo("
"); if(!$okladka==""){ echo("\"$tytul\""); } echo("$tytul

"); if($a<2){ echo("Autor"); }else{ echo("Autorzy"); } echo(" książki: "); $b="0"; while($autor[$b]!=""){ if($b>0){ echo(", "); } echo("$autor[$b]"); $autor[$b]=""; $b++; } echo("
Kategoria: $kateg
Data wydania: $miesiac[$miesks] $rokks

"); if($tresc[0]!=""){ echo("$tresc[0].    [więcej...]"); } echo("
 
 
"); } } if($j>$nownastr){ echo("

"); $max=ceil($j/$nownastr); if(!($str==1)){ $a=5; $st=$str-$a; while($st<=0){ $a--; $st=$str-$a; } $stp=$str-1; if($wyd!=""){ echo("<<<   "); if($str>6){ if($wyd!=""){ echo("1... "); }else{ echo("1... "); } } do{ if($wyd!=""){ echo("$st  "); }else{ echo("$st  "); } $a--; $st=$str-$a; }while($a>0&&$st>0); } echo("$str  "); if(!($str==$max)){ $b=1; $st=$str+$b; do{ if($wyd!=""){ echo("$st  "); }else{ echo("$st  "); } $b++; $st=$str+$b; }while($b<6&&$st<=$max); } if($wyd!=""){ echo("z  $max"); }else{ echo("z  $max"); } if(!($str==$max)){ $stn=$str+1; if($wyd!=""){ echo("   >>\">>>>"); } echo("

"); } dol(); ?>