From e83cf5a7875d1387d79d1909050ff2eca9b4421a Mon Sep 17 00:00:00 2001 From: Maryana Rozhankivska Date: Thu, 20 Feb 2014 10:41:16 +0200 Subject: multiple tag entry displayed fix, issue #474 --- inc/poche/Database.class.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'inc/poche/Database.class.php') diff --git a/inc/poche/Database.class.php b/inc/poche/Database.class.php index 3332b5a3..a366e866 100644 --- a/inc/poche/Database.class.php +++ b/inc/poche/Database.class.php @@ -345,7 +345,7 @@ class Database { } public function retrieveAllTags($user_id) { - $sql = "SELECT tags.* FROM tags + $sql = "SELECT DISTINCT tags.* FROM tags LEFT JOIN tags_entries ON tags_entries.tag_id=tags.id LEFT JOIN entries ON tags_entries.entry_id=entries.id WHERE entries.user_id=?"; @@ -357,7 +357,7 @@ class Database { public function retrieveTag($id, $user_id) { $tag = NULL; - $sql = "SELECT tags.* FROM tags + $sql = "SELECT DISTINCT tags.* FROM tags LEFT JOIN tags_entries ON tags_entries.tag_id=tags.id LEFT JOIN entries ON tags_entries.entry_id=entries.id WHERE tags.id=? AND entries.user_id=?"; -- cgit v1.2.3