summaryrefslogtreecommitdiffstats
path: root/phpfspot.class.php
diff options
context:
space:
mode:
Diffstat (limited to 'phpfspot.class.php')
-rw-r--r--phpfspot.class.php12
1 files changed, 9 insertions, 3 deletions
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
");
}