include "include_photos.php";
db_connect();
$result = mysql_query("SELECT * FROM reicht_photoGalleries WHERE id = '$gallery'");
$check = mysql_fetch_array($result, MYSQL_ASSOC);
if ($check)
{
$galleryname = mysql_result($result,0,"name");
$date = mysql_result($result,0,"date");
$place = mysql_result($result,0,"place");
$description = mysql_result($result,0,"description");
}
else
{
exit;
}
page_top("$galleryname");
echo "
";
echo "";
echo "";
echo "";
if (!$page) {
$page = 1;
}
$per_page = 9;
$prev_page = $page - 1;
$next_page = $page + 1;
$page_start = ($per_page * $page) - $per_page;
$num_rows = mysql_num_rows(mysql_query("SELECT id FROM reicht_photo WHERE galleryid = '$gallery'"));
if ($num_rows <= $per_page) {
$num_pages = 1;
} else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
} else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;
if (($page > $num_pages) || ($page < 0)) {
echo "You have specified an invalid page number";
}
$result = mysql_query("SELECT * FROM reicht_photo WHERE galleryid = '$gallery' LIMIT $page_start,$per_page");
$counter = 0;
echo "";
//echo "";
//echo "";
//echo "
while ($row = mysql_fetch_array($result)) {
$counter++;
if (($counter == "4") || ($counter == "7")) {
echo " |
|
\n";
echo " \n";
echo " ";
}
echo "$font";
echo " ";
echo " | ";
}
if ($counter < 3) {
while ($counter < 3) {
echo " | ";
$counter++;
}
}
elseif (($counter > 3) && ($counter < 6)) {
while ($counter < 6) {
$counter++;
echo " | ";
}
}
elseif (($counter > 6) && ($counter < 9)) {
while ($counter < 9) {
$counter++;
echo " | ";
}
}
echo " ";
echo "
|
";
if ($num_pages >= 2) {
echo " ";
echo " ";
echo "";
if ($prev_page) {
echo "Vorherige Seite | ";
}
else {
echo " | ";
}
echo "";
for ($i=1;$i<=$num_pages;$i++) {
if ($i != $page) {
echo " $i ";
}
else {
echo " $i ";
$ende = $i;
}
}
echo " | ";
if ($page != $num_pages) {
echo "Nächste Seite | ";
}
else {
echo " | ";
}
echo " |
";
}
else {
echo " ";
echo " ";
echo "Seite 1 | ";
echo " |
";
}
page_bottom();
?>
|