From: Andreas Unterkircher <unki@netshadow.at>
Date: Wed, 6 Jun 2007 20:38:10 +0000 (+0000)
Subject: sort images by time like f-spot does
X-Git-Tag: phpfspot-1.2~304
X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=phpfspot.git;a=commitdiff_plain;h=f5ebd8bd36353e5920031e7424ae02c212060b1b

sort images by time like f-spot does


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

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 27a0079..5b18be5 100644
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -176,14 +176,20 @@ class PHPFSPOT {
          $selected = substr($selected, 0, strlen($selected)-1);
          $result = $this->db->db_query("
             SELECT DISTINCT photo_id
-            FROM photo_tags
-            WHERE tag_id IN (". $selected .")
+               FROM photo_tags pt
+            INNER JOIN photos p
+               ON p.id=pt.photo_id
+            WHERE pt.tag_id IN (". $selected .")
+            ORDER BY p.time ASC
          ");
       }
       else {
          $result = $this->db->db_query("
             SELECT DISTINCT photo_id
-            FROM photo_tags
+               FROM photo_tags pt
+            INNER JOIN photos p
+               ON p.id=pt.photo_id
+            ORDER BY p.time ASC
          ");
       }