Galleri med forrige og næste funktion

PHP kode 

 <?php
  
  $photoID = $_GET['photosID'];
  $categoryID = $_GET['category'];
  
  $gallery = mysql_query("SELECT 
                          photos.photoID AS photoID,
                          photos.photo_date AS photoDATE,
                          photos.photo AS photo,
                          photos.description AS photoDesc
                          FROM photos
                          WHERE photos.photosID = '{$photoID}';
                          
                          IF EXISTS(SELECT photosID as NextID FROM photos WHERE fk_category_id = '$categoryID' AND WHERE NextID > '$photoID' ORDER BY NextID ASC LIMIT 1) 
                              THEN SELECT photosID as NextID FROM photos WHERE fk_category_id = '$categoryID' AND WHERE NextID > '$photoID' ORDER BY NextID ASC LIMIT 1;
                           ELSE 
                              SELECT photosID as NextID FROM photos WHERE fk_category_id = '$categoryID' AND WHERE NextID > 0 ORDER BY NextID ASC LIMIT 1;
                           END IF;
                          
                          IF EXISTS(SELECT photosID as prevID FROM photos WHERE fk_category_id = '$categoryID' AND WHERE prevID < '$photoID' ORDER BY prevID ASC LIMIT 1) 
                              THEN SELECT photosID as prevID FROM photos WHERE fk_category_id = '$categoryID' AND WHERE prevID < '$photoID' ORDER BY prevID ASC LIMIT 1;
                           ELSE 
                              SELECT photosID as prevID FROM photos WHERE fk_category_id = '$categoryID' ORDER BY prevID DESC LIMIT 1;
                           END IF;
                          ");
                          
  while($gallery_row = mysql_fetch_assoc($gallery))
  {
      $t = strtotime($gallery_row['photoDATE']);
      $dato = date("j/n-Y H:i", $t);
      
      print     '
                  <img style="border:0px" width="600" height="400" src="photos/'.$gallery_row['photo'].'"></img>
          
                  <div id="description_photo">
                      <span class="view_dates">
                          -Uploadet den. '.$dato.'-
                      </span>
                      <br />
                      <br />
                      '.$gallery_row['description'].'
                  </div>
                  <br />
                  <br />
                  <span class="read_comment">
                      <a href="photo.php?photosID='.$gallery_row['photosID'].'">Kommentar</a>
                  </span>
                  <span class="prev_image">
                      <a href="photo.php?photosID='.$gallery_row['prevID'].'">Forrige</a>
                  </span>
                  <span class="next_image">
                      <a href="photo.php?photosID='.$gallery_row['NextID'].'">Næste</a>
                  </span>
              ';
  }
  
  ?>

Kode 

<?php
 
 $photoID = $_GET['photosID'];
 $categoryID = $_GET['category'];
 
 $gallery = mysql_query("SELECT * FROM photos WHERE photos.photosID = $photoID");
                         
 while($gallery_row = mysql_fetch_assoc($gallery))
 {
     $t = strtotime($gallery_row['photo_date']);
     $dato = date("j/n-Y H:i", $t);
     
     print     '
                 <img style="border:0px" width="600" height="400" src="photos/'.$gallery_row['photo'].'"></img>
         
                 <div id="description_photo">
                     <span class="view_dates">
                         -Uploadet den. '.$dato.'-
                     </span>
                     <br />
                     <br />
                     '.$gallery_row['description'].'
                 </div>
                 <br />
                 <br />
                 <span class="read_comment">
                     <a href="photo.php?photosID='.$gallery_row['photosID'].'">Kommentar</a>
                 </span>';
 }
 
 $next_query = mysql_query("SELECT photoID FROM photos WHERE fk_category_id = '$categoryID' AND photosID > $phoyoID ORDER BY photoID ASC LIMIT 1")
 
 if(mysql_num_rows($next_query) == 0)
 {
	$next_query = mysql_query("SELECT photoID FROM photos WHERE fk_category_id = '$categoryID' ORDER BY photosID ASC LIMIT 1");
 }
 
 if(mysql_num_rows($next_query) == 1)
 {
	list($nextID) = mysql_fetch_assoc($query);
	
	print '<span class="next_image">
			<a href="photos.php?category_id='. $categoryID . '&photosID=' . $nextID . '">Næste</a>
		  </span>';
}
 
 ?>

PHP kode 

 <?php
  
  $photoID = $_GET['photosID'];
  $categoryID = $_GET['category'];
  
  $gallery = mysql_query("SELECT * FROM photos WHERE photos.photosID = $photoID");
                          
  while($gallery_row = mysql_fetch_assoc($gallery))
  {
      $t = strtotime($gallery_row['photo_date']);
      $dato = date("j/n-Y H:i", $t);
      
      print     '
                  <img style="border:0px" width="600" height="400" src="photos/'.$gallery_row['photo'].'"></img>
          
                  <div id="description_photo">
                      <span class="view_dates">
                          -Uploadet den. '.$dato.'-
                      </span>
                      <br />
                      <br />
                      '.$gallery_row['description'].'
                  </div>
                  <br />
                  <br />
                  <span class="read_comment">
                      <a href="photo.php?photosID='.$gallery_row['photosID'].'">Kommentar</a>
                  </span>';
  }
  
  $next_query = mysql_query("SELECT photoID FROM photos WHERE fk_category_id = '$categoryID' AND photosID > $photoID ORDER BY photoID ASC LIMIT 1")
  
  if(mysql_num_rows($next_query) == 0)
  {
     $next_query = mysql_query("SELECT photoID FROM photos WHERE fk_category_id = '$categoryID' ORDER BY photosID ASC LIMIT 1");
  }
  
  if(mysql_num_rows($next_query) == 1)
  {
     list($nextID) = mysql_fetch_assoc($query);
     
     print '<span class="next_image">
             <a href="photos.php?category='. $categoryID . '&photosID=' . $nextID . '">Næste</a>
           </span>';
 }
  
  ?>