From: Andreas Unterkircher <unki@netshadow.at>
Date: Sat, 12 Jan 2008 11:00:30 +0000 (+0100)
Subject: issue97, add missing DISTINCT keyword to SQL query
X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=phpfspot.git;a=commitdiff_plain;h=2283995d7df3de43454a11729a3296c5300d0f49;hp=50466123d97dd9d1afe299cba60e11be61f5077a

issue97, add missing DISTINCT keyword to SQL query

Signed-off-by: Andreas Unterkircher <unki@netshadow.at>
---

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 9cffc58..c2ec3ac 100644
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -874,7 +874,7 @@ class PHPFSPOT {
 
       /* return all available photos */
       $query_str = "
-         SELECT p.id
+         SELECT DISTINCT p.id
          FROM photos p
          LEFT JOIN photo_tags pt
             ON p.id=pt.photo_id
@@ -886,10 +886,10 @@ class PHPFSPOT {
          $query_str.= "WHERE ". $additional_where_cond ." ";
 
       if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
-	 if(isset($additional_where_cond))
-	    $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags). "')";
-	 else
-	    $query_str.= "WHERE t.name IN ('".implode("','",$this->cfg->show_tags). "')";
+         if(isset($additional_where_cond))
+            $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags). "')";
+         else
+            $query_str.= "WHERE t.name IN ('".implode("','",$this->cfg->show_tags). "')";
       }
  
       if(isset($order_str))