aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2004-12-06 21:49:32 +0000
committerplegall <plg@piwigo.org>2004-12-06 21:49:32 +0000
commit2201f60d0b7f723b6a7c61c20f38694d1e81b5b8 (patch)
treeac1f76ddfa29556cc0d2c89333112f29a574ecdf
parent1ab32cccb7eaf8f5707c06895179e31743dceae9 (diff)
- bug fixed : when a picture is linked to more than 1 category, it was shown
monre than once in picture.php for special categories like most visited, search, etc... git-svn-id: http://piwigo.org/svn/trunk@639 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--picture.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/picture.php b/picture.php
index e0af0b062..570bf6dc4 100644
--- a/picture.php
+++ b/picture.php
@@ -96,9 +96,9 @@ else
}
$query = '
-SELECT *
- FROM '.IMAGES_TABLE.'
- INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=ic.image_id
+SELECT DISTINCT(i.id), i.*
+ FROM '.IMAGES_TABLE.' AS i
+ INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
'.$page['where'].'
'.$conf['order_by'].'
';