diff options
| -rw-r--r-- | phpfspot.class.php | 26 |
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 ."&width=". $this->cfg->thumb_width ."\" /><br />\n"; } |