Changeset 639


Ignore:
Timestamp:
Dec 6, 2004, 10:49:32 PM (19 years ago)
Author:
plg
Message:
  • 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...
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/picture.php

    r635 r639  
    9797
    9898$query = '
    99 SELECT *
    100   FROM '.IMAGES_TABLE.'
    101     INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=ic.image_id
     99SELECT DISTINCT(i.id), i.*
     100  FROM '.IMAGES_TABLE.' AS i
     101    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
    102102  '.$page['where'].'
    103103  '.$conf['order_by'].'
Note: See TracChangeset for help on using the changeset viewer.