diff options
| author | plegall <plg@piwigo.org> | 2004-12-06 21:49:32 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2004-12-06 21:49:32 +0000 |
| commit | 2201f60d0b7f723b6a7c61c20f38694d1e81b5b8 (patch) | |
| tree | ac1f76ddfa29556cc0d2c89333112f29a574ecdf /picture.php | |
| parent | 1ab32cccb7eaf8f5707c06895179e31743dceae9 (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.php | 6 |
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'].' '; |