diff options
| -rw-r--r-- | phpfspot.class.php | 12 |
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 "); } |