"; $Deutsch["letzte"] = ">>"; $Englisch["nichtgefunden"] = "Sorry, no matches were found"; $Englisch["erste"] = "<<"; $Englisch["zurueck"] = "<"; $Englisch["vor"] = ">"; $Englisch["letzte"] = ">>"; $Sprache = $$_SESSION['Language']; $config = mysql_fetch_array(mysql_query("SELECT * from config")); //echo $baseQueryEncode; if($pages != "" && $baseQueryEncode != "" && $page != "") { $baseQuery = base64_decode($baseQueryEncode); }else { if($search != "") { $baseQuery = "WHERE " . query_text($search); } elseif ($news == "1") { $baseQuery = "JOIN (SELECT id FROM `produkte` ORDER BY NUMS DESC LIMIT 0 , 100 ) AS prod2 ON produkte.id = prod2.id"; //$QUERY = "SELECT * FROM `produkte` ORDER BY NUMS DESC LIMIT 0 , 100"; } elseif($UKat != "") { $baseQuery = "WHERE " . mysql_evaluate("SELECT Query FROM Kategorien WHERE ID = ".$UKat); } elseif($HKat != "") { $baseQuery = "WHERE " . mysql_evaluate("SELECT Query FROM Kategorien WHERE ID = ".$HKat); } else { $baseQuery = "WHERE ZUO NOT like '%Kunst%' AND ZUO NOT like '%Karten%' AND ZUO NOT like '%Graphik%' AND EA like '' AND ZUO NOT like '%naturwissenschaften%' AND ZUO NOT like '%Psychologie%' AND ZUO NOT like '%Medizin%' AND ZUO NOT like '%Philosophie%'"; } $page = 1; $booksFound = mysql_evaluate("SELECT Count(*) FROM produkte ".$baseQuery ,0); $pages = ceil($booksFound/$_SESSION['BooksPerPage']); $baseQueryEncode = base64_encode($baseQuery); } $pageLine = ""; $links = 5; $baseHref = $PHP_SELF."?pages=".$pages."&baseQueryEncode=".$baseQueryEncode."&page="; $start = $page - $links; if ($start < 1) $start = 1; if ($page < 5) $start = 1; $end = $page + $links; if ($end < 10) $end =10; if ($end > $pages) $end = $pages; if ($pages > 10 && ($end - $start) < 10) $start = $end-10; if ($start < 1) $start = 1; if ($page > 2) $pageLine .= "".$Sprache[erste].".."; if ($page > 1) $pageLine .= "".$Sprache[zurueck].".."; for ($i=$start; $i <= $end; $i++) { if($i == $page) { $pageLine .= " ".$i." "; } else { $pageLine .= " ".$i." "; } } if (($pages - 1) >= $page) $pageLine .= "..".$Sprache[vor].""; if (($pages - 2) >= $page) $pageLine .= "..".$Sprache[letzte].""; $QUERY ="SELECT * FROM produkte ".$baseQuery." ORDER BY SORT, AUT, TIT LIMIT ".($_SESSION['BooksPerPage']*($page-1)).",".$_SESSION['BooksPerPage']; //echo $QUERY; ?> Antiquariat Burgverlag
1) echo $pageLine?>

cart_waehrung(); if(mysql_num_rows($result) != "0") { while($row = mysql_fetch_array($result)) { $row["preis"] = $row["VPE"] * $kurs["kurs"]; $preis = sprintf ("%01.2f", $row["preis"]); $text = auflistung_text($row); echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo "

".$row["NUM"]." "; if(mysql_num_rows(mysql_query("SELECT * from bilder where NUM like '$row[NUM]'")) != "0") echo ""; echo $text."

".$kurs["waehrung"]." ".$preis."

"; } ?>
1) echo $pageLine?>

".$Sprache["nichtgefunden"]."

"; echo ""; } ?>