Code:
<?php include("dbconnect.php"); $max_pics = 9; // Anzahl der Bilder, die pro Seite angezeigt werden sollen $count = mysql_query("SELECT id FROM bilder"); $number_pics = mysql_num_rows($count); $links_to_pages = " "; for($i=1;$i>=$number_pages;$i++) { $links_to_pages .= " | <a href=$PHP_SELF?page=$i>$i</a>"; } $number_pages = (int) (($number_pics-1)/$max_pics)+1; if (!$page) { $page = $number_pages; } $start_pic = (($page-1) * $max_pics); echo " "; if ($page > 1) { $page_prev = $page - 1; echo "Zurück"; } if ($page < $number_pages) { $page_next = $page + 1; echo "Weiter"; } echo "</p>"; echo $links_to_pages; $abfrage = "SELECT * FROM bilder ORDER BY id DESC LIMIT $start_posting,$max_postings"; $ergebnis = mysql_query ($abfrage, $connection); while ($row = @ mysql_fetch_array($ergebnis)) { ...Ausgabe... } ?>
Kommentar