fixed SQL syntax error on AND conjunction of multiple tags

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

diff --git a/phpfspot.class.php b/phpfspot.class.php
index f572759ed1262c8d98d01ef61ed009168b0f696f..2c3170c869e7395d5bd64bff9e7965f6d1f8fdfa 100644 (file)
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -636,6 +636,10 @@ class PHPFSPOT {
                      ON pt1.photo_id=pt". ($i+2) .".photo_id
                ";
             }
                      ON pt1.photo_id=pt". ($i+2) .".photo_id
                ";
             }

+            $query_str.= "
+               INNER JOIN photos p
+                  ON pt1.photo_id=p.id
+            ";

             $query_str.= "WHERE pt1.tag_id=". $_SESSION['selected_tags'][0];
             for($i = 1; $i < count($_SESSION['selected_tags']); $i++) {
                $query_str.= "
             $query_str.= "WHERE pt1.tag_id=". $_SESSION['selected_tags'][0];
             for($i = 1; $i < count($_SESSION['selected_tags']); $i++) {
                $query_str.= "


@@ -1633,21 +1637,19 @@ class PHPFSPOT {
    {
       switch($_SESSION['sort_order']) {
          case 'date_asc':
    {
       switch($_SESSION['sort_order']) {
          case 'date_asc':

-            return "ORDER BY p.time ASC";
+            return " ORDER BY p.time ASC";

             break;
          case 'date_desc':
             break;
          case 'date_desc':

-            return "ORDER BY p.time DESC";
+            return " ORDER BY p.time DESC";

             break;
          case 'name_asc':
             break;
          case 'name_asc':

-            return "ORDER BY p.name ASC";
+            return " ORDER BY p.name ASC";

             break;
          case 'name_desc':
             break;
          case 'name_desc':

-            return "ORDER BY p.name DESC";
+            return " ORDER BY p.name DESC";

             break;
       }
 
             break;
       }
 

-      return $_SESSION['sort_order'];
-

    } // get_sort_order()
 }
 
    } // get_sort_order()
 }