diff options
| author | z0rglub <z0rglub@piwigo.org> | 2003-09-05 19:27:45 +0000 |
|---|---|---|
| committer | z0rglub <z0rglub@piwigo.org> | 2003-09-05 19:27:45 +0000 |
| commit | 4f6dabea73678e2dad683d160eef8fedc562e8c6 (patch) | |
| tree | f650fad5fcac6e6639bb027e8a5e8b587deb7356 /category.php | |
| parent | 839771e0b692ebf468fcfbecec95d6e27c439394 (diff) | |
Correcting a bug in special categories (favorites, most seen, most
recent... non numeric categories) : when a picture is linked to more than
one category, it's only displayed once.
git-svn-id: http://piwigo.org/svn/trunk@64 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
| -rw-r--r-- | category.php | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/category.php b/category.php index 2264be614..1db16ffa0 100644 --- a/category.php +++ b/category.php @@ -233,10 +233,10 @@ if ( isset( $page['cat'] ) and $page['cat_nb_images'] != 0 ) { $array_cat_directories = array(); - $query = 'SELECT id,file,date_available,tn_ext,name,filesize'; - $query.= ',storage_category_id,category_id'; - $query.= ' FROM '.PREFIX_TABLE.'images'; - $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id = image_id'; + $query = 'SELECT distinct(id),file,date_available,tn_ext,name,filesize'; + $query.= ',storage_category_id'; + $query.= ' FROM '.PREFIX_TABLE.'images AS i'; + $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic ON id=ic.image_id'; $query.= $page['where']; $query.= $conf['order_by']; $query.= ' LIMIT '.$page['start'].','.$page['nb_image_page']; @@ -251,6 +251,7 @@ if ( isset( $page['cat'] ) and $page['cat_nb_images'] != 0 ) $line_number = 1; while ( $row = mysql_fetch_array( $result ) ) { + // retrieving the storage dir of the picture if ( $array_cat_directories[$row['storage_category_id']] == '' ) { $array_cat_directories[$row['storage_category_id']] = |