limit displayed photos within index to tag selection

git-svn-id: file:///var/lib/svn/phpfspot/trunk@21 fa6a889d-dae6-447d-9e79-4ba9a3039384

1 files changed, 25 insertions, 1 deletions

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 20ab36d..168d081 100644
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -186,10 +186,34 @@ class PHPFSPOT {
 
    } // resetTags()
 
+   public function getAllTagPhotos()
+   {  
+      $selected = "";
+      foreach($_SESSION['selected_tags'] as $tag)
+         $selected.= $tag .",";
+      $selected = substr($selected, 0, strlen($selected)-1);
+
+      $tagged_photos = Array();
+
+      $result = $this->db->db_query("
+         SELECT DISTINCT photo_id
+         FROM photo_tags
+         WHERE tag_id IN (". $selected .")
+      ");
+
+      while($row = $this->db->db_fetch_object($result)) {
+         array_push($tagged_photos, $row['photo_id']);
+      }
+
+
+      return $tagged_photos;
+
+   } // getAllTagPhotos()
+
    public function showPhotoIndex()
    {
 
-      foreach($this->avail_photos as $photo)
+      foreach($this->getAllTagPhotos() as $photo)
       {
          print "<img src=\"phpfspot_img.php?idx=". $photo ."&amp;width=". $this->cfg->thumb_width ."\" /><br />\n";
       }